Displaying of number on form

[Niko]

Hi guys, I had no idea why the number that display on my form is different from the number in my database. How can i fix that?


I have tried changing the data type in my table for styleNO to number but it still will not work.
The first image refers to the number on my database that should appear the on my form
The second image refers to the number that is on my form

[June7]

Since these are really identifier values, not truly numeric like a quantity, could be a text field.

Is the textbox Format property set to Scientific?

[Niko]

Since these are really identifier values, not truly numeric like a quantity, could be a text field.

Is the textbox Format property set to Scientific?

I tried setting it to short/long text still the same.
I set the textbox to general number

[June7]

Try Fixed format. Decimal Places set to 0.

Or change field to text type.

[Niko]

Try Fixed format. Decimal Places set to 0.

Or change field to text type.

OMG! I change the textbox property to fixed and no decimal place and it works!!
Thank you so much!!