Table Quirk

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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]
 
Just the one table. Number is it's datatype. 2 decimals is the format,
Single Byte.
 
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]
 
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...
 
You must log in or register to reply here.

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

Access Updating inventory levels 0
DELETE FROM a table WHERE... 1
Appending new columns from one table into a static table 5
Updating tables when you input new data 0
Need Suggestions to Eliminate Unplanned Table Behavior 4
The sum of 2 fields in an access table 2
Linked Tables 2
Access Dcount (multiple criteria) 3

Back
Top