format and decimals in control text

L

LP

Hi
format and decimals in a text box do not seem to work as expected.
I can set format to general number or leave it blank and decimals to 0 or 1,
makes no difference, I get 1 decimal in some text boxes and no decimals in
others. the decimals are not rounded off either, they can be .3 or .9. does
anyone know why and how to deal with this problem?
regards
 
M

Marshall Barton

LP said:
format and decimals in a text box do not seem to work as expected.
I can set format to general number or leave it blank and decimals to 0 or 1,
makes no difference, I get 1 decimal in some text boxes and no decimals in
others. the decimals are not rounded off either, they can be .3 or .9. does
Click to expand...


That's means that you are trying to use those formatting
options on a text value. Try to backtrack where the text
box's value is coming from to see if you can figure out
how/why it became text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable/Adaptive Numeric Format 2
Getting decimal places to display in a report in text boxes 1
Currency format with 2 decimals not showing on report 2
Problem formatting data in text fields in Access Report 4
decimal problems in reports 4
Decimals errors in reports 1
Display of numerical value with decimals in a text box 5
Nested If statement to control format of number-type cells 3

Top