Printing a 'tick' on a form

Comments

• gordk St.Catherines On. Canada.

  January 2005 edited 3:35AM

  Hi Pete
  you could use a checkbox object and set its checked prop to true or false
  or use a memo and the wingding font, use an if expression to decide if the memo shows check or '', this way you can control sizing and frame size thickness
  
• petesouthwest

  January 2005 edited 3:35AM

  Hiya
  
  I did as you suggested; made the database store 'Y' or 'N', and then used a richtext object with the expression:
  
  if([query1."ass1edn"]='Y','√','x')
  
  where the '√' was wingdings font that looked like a better tick!
  
  However, when i first run the project and viewed the report I got errors showing a couple of odd charactors and saying about it not being a valid floating point number, and now I just get a report showing the word 'if'. I'm not sure exactly what I did that caused the error to go
  
  I tried [if([query1."ass1edn"]='Y','√','x')] too
  
  
  I'm not sure what I'm missing.
  
  Thanks for your help
  Pete
• petesouthwest

  January 2005 edited 3:35AM

  Sorry I had a space after the 'if' the expression works now.
  
  except......
  
  Now instead of the the wingdings tick I get a latin u? hmmmmm
• gordk St.Catherines On. Canada.

  January 2005 edited 3:35AM

  try using the alt+keycode in the string check windows charmap to get correct keycode.
• petesouthwest

  January 2005 edited 3:35AM

  Hiya
  
  Thanks for the help I also found that if i format the whole expression as wingdings, rather than just the tick that worked too!
  
  Cheers
  Pete