Problems with inputting currency in a form

[kidfortoday]

Hi All,

So I have a form that is bound.

In particular I have a text book whose control source is a field in a
table. Its format is currency.

The problem is: if the form is in regular view and someone goes to the
text box and types 4, it comes up as 40.

Any help is much appreciated.

Thanks,
K

 

[OldPro]

Hi All,

So I have a form that is bound.

In particular I have a text book whose control source is a field in a
table. Its format is currency.

The problem is: if the form is in regular view and someone goes to the
text box and types 4, it comes up as 40.

Any help is much appreciated.

Thanks,
K

If there is already a zero in the textbox, then clicking on the
textbox allows you to "edit" the amount. If someone had input
"9234.23" and meant to input 90234.23 then it would be easy to edit
without reentering the whole number. If it is the first time, then
the field should be set to the default of NULL. Do not use an input
mask; they are somewhat clumsy and don't work well with numbers in
some versions of Access. If you really want the field to go blank
when the textbox is selected then put this code in the On Got Focus
event: txtBoxName=NULL. This will lose any value already in the
textbox. This is usualy a bad idea IMHO.