Table Quirk

D

dar

I asked this question several months ago, and no response.
I am using Access 2000 and have a table which is populated via a form.
When I open the table in datasheet view, the numbers don't show up in a
particular
field unless I place the cursur in the field. Then the number does show up.
As soon as I move out of the field, it appears blank again.
The reports based on the table are accurate so it registers the numbers.
Can anyone explain why this is happening?
 
J

John Vinson

I asked this question several months ago, and no response.
I am using Access 2000 and have a table which is populated via a form.
When I open the table in datasheet view, the numbers don't show up in a
particular
field unless I place the cursur in the field. Then the number does show up.
As soon as I move out of the field, it appears blank again.
The reports based on the table are accurate so it registers the numbers.
Can anyone explain why this is happening?
Click to expand...

Does this happen for all tables in the database, or just one? What's
the datatype of the field? Have you specified any Format property for
the field?

John W. Vinson[MVP]
 
J

John Vinson

Just the one table. Number is it's datatype. 2 decimals is the format,
Single Byte.
Click to expand...

Since a single byte integer cannot have decimal places, and can only
take on the values -128 through 127, I'm curious that you chose that
format. What do you see if you change the decimal places to 0?

John W. Vinson[MVP]
 
D

dar

No change.
John Vinson said:
Since a single byte integer cannot have decimal places, and can only
take on the values -128 through 127, I'm curious that you chose that
format. What do you see if you change the decimal places to 0?

John W. Vinson[MVP]
Click to expand...
 
Top