auto decimal?

[Hannainnc]

Is there a way to make some of the entry fields in my form auto add the decimal so that when users do data entry they do not have to enter the decimal point? I can do it in excel, but I haven't figured out how to do in Access form.

I want to be able to just enter 456755 and it format correctly, when the actual number is 4567.55.

Any help for a newb would be great!

 

[ColinEssex]

Check out Input Mask in Access help - you may be able to do it there

Col

 

[Hannainnc]

right, i tried that, but it says input mask only works for text and dates.

 

[andyski101]

You could custom type the mask such as 9990\.99 or set it as text first, use the wizard and then change it back to a number.

You could also try setting the format and required decimal places.

These options depend on how much your numbers vary in terms of length and number of decimal places.