How do I display number field in Access?

[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.

 

[Jeff Boyce]

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

 

[Guest]

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.

 

[Jeff Boyce]

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