How can I change text box from number to text?

J

Jenna

I created a database a while back and now I can't remember how I set up the
text box to be number only. I want to change it to text now because things
have changed, but I can't seem to figure out how. Also, the numbers I do
have are rounding, how can I stop the field from rounding? I changed the
decimal places to a high number and it still continues to round.

Any help would be appreciated!

Thank you,
Jenna
 
J

John W. Vinson

I created a database a while back and now I can't remember how I set up the
text box to be number only. I want to change it to text now because things
have changed, but I can't seem to figure out how. Also, the numbers I do
have are rounding, how can I stop the field from rounding? I changed the
decimal places to a high number and it still continues to round.

A Textbox is a control on a Form. It's not a data repository, and it isn't a
"number" or a "text" - it's JUST A WINDOW.

The data is actually stored in a field in a Table. *That's* where you have the
problem. Open the Table in design view; select this field; and change its
datatype from Number (Long Integer, the default) to Text.

There are several different Number datatypes; the default is Long Integer,
which is by definition a whole number. If you want numbers with decimals, use
Number... Single, Number... Double, Number... Decimal (on the properties of
the field in the lower left of the table design window); or use a Currency
datatype instead of a Number datatype.

John W. Vinson [MVP]
 

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

Top