Numeric field display on a form

[5166narda]

I want to display a numeric field as blanks on a form but instead it shows as zero and when I click on the field, the zero stays as part of the entered number. How do I make a zero field show as null?

 

[KenReay]

Hi

put # in the format property of the column, seems to work, I have just tried it

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[5166narda]

thanks - that worked.