Number Format in Textbox

[hlam]

Hello,

How do I set a textbox in form to show:-
- blank if the contain is zero
- 7.25 if the contain is 7.25
- 7 if the contain is 7

I tried to set to General Number it shows 0 if it is zero.
I tried to set to #.##;-#.##;"" it shows a period if it is zero, also it
reserves 2 spaces at the right most.

Thanks for your help.

HL

 

[Eric Blitzer]

Insted of in your form why not format the field in your table.
In your table design for that field
Set the Decimal Places to "auto"
set the default value to 0

I fyou already have data in your table run an update query changing all
nulls to 0.