how to change 0(zero) to -

Comments

• micropro

  February 2007 edited February 2007

  Hi,
  
  In your memo, enter this statement:
  [IIF(<DATASET."FIELD"> = 0,'-',<DATASET."FIELD">)]
  
  here is what it means:
  if (value = 0) then (show "-") else (show value)
  so [IFF(CONDITION, IF TRUE, IF FALSE)]
  
  hope this answers your question,
  
  micro
• putukaca

  March 2007 edited 1:41PM

  why it's raise error project invoice.exe raised exception class EVarianTypeCastError with message 'could not convert variant of type (string) into type (double)'
• gordk St.Catherines On. Canada.

  March 2007 edited 1:41PM

  you probably have the display format for the memo set to numeric.
  if you wish to keep display format then do your mods in the obp event of the band and modify the memos properties and contents from there, and reset the memo's props in it's oap event.