How can I input more than 1 number in a field?

[Guest]

I need to be able to input more than 1 number into a field. Everytime I do
this it gives me an error.

 

[Guest]

Hi

Can you give an example of the type of number your are trying to enter
ie.
123
1.23
12.1234

Also what is the format of the field (look in the table)

All of these bit of information would be useful

 

[Bill Mosca, MS Access MVP]

Could it be that the field is really text and only 1 character in size?

 

[John Vinson]

I need to be able to input more than 1 number into a field. Everytime I do
this it gives me an error.

In addition to the suggestions from Wayne and Bill... note that fields
in a database are designed to be "atomic". If you're trying to store
two pieces of information in one field (especially a Number datatype
field) DON'T! It's simply *incorrect design* to do so. You may need
another Table.

John W. Vinson[MVP]

 

[Ron2006]

If the field is defined as numeric, it will complain at the first space
that you are trying to put in there.

one numeric field equates to one numeric value.
NO Exceptions.

Ron