63.7777777777777777

[Guest]

Dear all ,

I have an unbound text box on my form that's used to view the resukt of a
certain calculation: the results appear like this 63.7777777777777777
While i want it to appear like this 63.77

What should i do ?

Regards

 

[David]

Open that table in design view. Select the field you want to set the
decimal places on. Then in the general tab select 2 for the decimal places
field. I'm kind of new to access but I think that will work.

Make sure the data type says number.

 

[Guest]

Format([TextField], "0.00")

Also you should be able to right click on the text box and bring up the
Properties. From there you can select the format.

 

[JK]

Change your calculation to:
Me.YrTxtBox=Round(Your calculation,2)

set the Decimal Place to 2

Regards/JK