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

On Tue, 27 Mar 2007 18:06:28 -0700, Jenna <(E-Mail Removed)>
wrote:

>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]