Hi there! i just want to ask how to set the textbox so it will display decimal numbers. Couse now if i read a decimal number from my access database like 0,2 it displays only 0 Tnx for the help!
A:
Check the format options on the text box to make sure it is set to fixed or standard and the number of decimal places is more than 0!
EDIT:
Here is a more verbose answer
- Open the form in design mode
- Make sure the properties window is displayed, if it is not then right click on the control and click on properties
- Go to the “Format” tab, under that tab is a field called “format” and another called “decimal places”
- Alter these so they show “General Number” and “Auto”
That should do the trick
Kevin Ross
2010-04-30 07:12:54
where can i do that?
simon
2010-04-30 12:53:05
Kevin - simon is not working in access but coding in C# so your verbose answer won't help much...
Murph
2010-04-30 13:17:29
This is one of the problems with the MS-ACCESS tag -- it covers too much. In this case, Access is not involved at all, only the Jet/ACE database engine. I started answering this yesterday before I realized that it wasn't an Access question at all.
David-W-Fenton
2010-04-30 21:25:30
@david Very good point about the tags and how most people think jet=access.
Kevin Ross
2010-05-01 13:54:37
I think it's good for your answer to be here, since someone working in Access could get to this question seeking the very explanation you've given, even though it's not applicable to the specific question.
David-W-Fenton
2010-05-02 00:36:06