Problem when displaying a value

[nartla]

Hello,

I am displaying a value in a textbox of a form (mytextbox.Caption =
14595" , and the result in display is : 1,4595E+04

Is there a way to force Access to display the value as 14595 and not
as 1,4595E+04 ?

Thank you.

 

[Allen Browne]

I'm confused.

If this is a text box, it does not have a Caption property. Just set the
Format property to:
General Number
of possible Fixed.

If it is a label, try:
MyLabel.Caption = Format(14595, "General Number")

 

[Marshall Barton]

I am displaying a value in a textbox of a form (mytextbox.Caption =
14595" , and the result in display is : 1,4595E+04

Is there a way to force Access to display the value as 14595 and not
as 1,4595E+04 ?

Either there is something very strange going on, you have
something odd in the text box's Format property or the type
of the field is Single/Double and its value is something
like 14595,00000123

If the field in the table is Single/Double and you do not
want to display a miniscle fractional part, try setting the
text box's Format property to a specific format such as 0 or
0.00