Currency field in form - updating wrong, HELP.

[rthakral]

Good morning,

I have a question about entering in currency on a field in one of my forms in my DB.

Essentially the problem I'm having is this: Upon entering a dollar amount, for example say I want to add $350,621.

It shows up like this: $35,062,1

How do I fix this issue? That happens because it is filling in left to right when I tab down to the field, but if it fills in right to left I'm sure it'll fill properly. How do I go about fixing this issue.

Please advise!! Any help would be greatly appreciated!! Thank you!

[Rainlover]

In your Table do you have the Data Type as Currency.

Then in the General Tab the Format should be Currency and the Decimal Places set to 2.

Do not enter the $ symbol as this is automatic.

In your Form you should not need to set anything as the formatting will flow through.

If you have changed the properties in the form control, then delete it and add a new one.

Hope this helps. It has not been tested as there is nothing to test against.

[rthakral]

Thank you!!! It most certainly helped.

[Rainlover]

Did it just help or is your problem solved.

I don't want to leave you with a problem.

[rthakral]

your answer solved my problem. thanks again!!