Re: How do I display number field in Access?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

"Duckydee" <Duckydee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CA712AD2-C1CE-4619-B533-5BBB1B42EEBC@xxxxxxxxxxxxxxxx


"Jeff Boyce" wrote:

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


"Duckydee" <Duckydee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1227908F-D1D4-41A9-B5C4-B17E6D11D5C5@xxxxxxxxxxxxxxxx
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.


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.


.

Relevant Pages

  • Re: Problem Importing from an Excel spread sheet to an Access 2003 table.
    ... display 5 digits with a single command? ... displayed as 5 digits and 5 digits only. ... >1) Modify the Excel sheet before import by prefixing an ... leading zeros. ...
    (microsoft.public.access.externaldata)
  • Re: display contents of preceeding cells consecutively
    ... You're *still* going to have a problem since you're working with 16 digits ... the display is more important to me at this point ... If you want leading zeros then you'll have to accept the ... If the resulting string wll be longer than that then ...
    (microsoft.public.excel.misc)
  • Re: How do I display number field in Access?
    ... If your input number is preceeded by any number of leading zeros, ... text characters that happen to be digits. ... is that when Access imports the data, that numbers will not display, I get ...
    (microsoft.public.access.externaldata)
  • Re: view leading zeros
    ... type and display formatting. ... > starting with a zero or two zeros the zeros are not displayed, ... > is it possible to display all 4 digits Inc the leading zeros. ...
    (microsoft.public.access.gettingstarted)
  • Re: Leading zeros
    ... I'm guessing your table definition formats that to display ... Text fields can have leading zeros because text is text, and a "0" character ... Jeff Boyce wrote: ...
    (microsoft.public.access.queries)