How to display leading sign (+/-) Access number fields?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to display a leading sign for a number field (calculated) in Access.
Preferably in a form, but can deal with a query.
 
in a form, set the Format property of the calculated control to

+0;-0

see the "Format Property - Number and Currency Data Types" topic in Access
Help.

hth
 
Your format property value looks the the emoticon of a Screaming and Winking
Christian Royalty.
 
Back
Top