format

[krishnanhemanth]

hi

i have a lot of calculated textboxes on my forms like

quantity
amount
pending period
etc....

i format the above in this fashion

quantity---- i go to properties....format... and type....# "nos"
it outputs this way....100 nos

what i want is...
if the quantity is 1...then format output......1 nos
if the quantity is 0...then format output......nil

how can i do this

 

[MarkK]

The article entitled 'Format Property - Number and Currency Data Types' in Access VBA help might be very helpful.
Cheers,