var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Currency Value £0.00 how to hide
Someone please help me with this,
I have a form with a currency field, if it shows £0.00 i want to hide it..
whats the easiest way to do that?
Hide the control, you mean?
Where Amount is the name of the control.
Private Sub Form_Current()
If Nz(IsNull(Me.Amount.Value), 0) = 0 Then
Me!Amount.Visible = False
Me!Amount.Visible = True
Have a nice day!
If you simply don't want to display zeros, you can also use the format property of a textbox. For numeric fields, it can have four parts, one of which is zero values.