Limit Display in Text Box

[accessuserva]

How Do I Limit the display in a text box to only 1 decimal place. The query from which it is pulling its data only has 2 decimal places but when the text box fills it goes out to 8 decimal places. I have the text box formated for "fixed" with 1 decimal place. Any suggestions

accessuserva

 

[KenReay]

Hi

I would have expected the format you have set in the text box properties would have done the trick, but if it is not you could try cahnging the query to return one decimal by making the value column a calculated column eg OneDec:Format(twodec,"######.#&quot

Regards

Ken Reay