How do I display number field in Access?

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

Guest

I am trying to create a database by an fixed width ascii text file. The
number field is 13 digit number, including two leading zeros. I have
formatted the field in Access for a numeric, long integer type. My problem
is that when Access imports the data, that numbers will not display, I get no
numbers at all. Can anyone help!!!!!
Thanks in advance.
 
Where? ... as in "where are you trying to get this to display"?

If your input number is preceeded by any number of leading zeros, it may not
be a real number (something you'd add/subtract). Instead, it may be just
text characters that happen to be digits. Can you confirm that you need to
add/subtract this number?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff Boyce said:
Where? ... as in "where are you trying to get this to display"?

If your input number is preceeded by any number of leading zeros, it may not
be a real number (something you'd add/subtract). Instead, it may be just
text characters that happen to be digits. Can you confirm that you need to
add/subtract this number?

Regards

Jeff Boyce
Microsoft Office/Access MVP





I am attempting to get the field to display when I go into the Table view in Access. I have also tried to create a query to display the field, but there again, the field shows up blank with no numbers. No I do not need to add or subtract these numbers. I think that the field is a text field that happens to be digits. It is an acct. number field where all accts. begin with the two zeros.
Click to expand...
 
If, when you open a table, you don't even see that column, I'd guess it had
been hidden. Try the Windows menu choice and see if you can unhide
anything.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top