Access 2010  table field looks different in the linked table

Posted on 2013-05-28
Medium Priority
Last Modified: 2013-05-28
Access 2010:  We have a table with a number field, Field Size: double  The field shows up differently in the linked table.
We have an account table. Field: Account Type: Number Field Size: Double
 Backend table: ex Acct number: 23040160331065
 In the linked table the field above  looks like this: 2.3040160331065E+13
 Why doesn't it look the same?
Question by:abcctech
  • 2
LVL 59

Accepted Solution

Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 39202308

  A double is a numeric float value and depending on column width, will be displayed in exponential format.

  You can apply a format for it to display properly in a control.

  However I would advise against using a numeric field type for an account number.  Instead use a text field.

 One reason is leading zero's will be stripped off.


Author Comment

ID: 39202571
Hi Jim,
 Thanks for your quick reply.
 This database has been in use for a long time.  They just started putting in the long account numbers.   I hesitate to change it at this time...
How do I format the form for it to show correctly?  
Do I have to do anything to the linked table?

Thanks again,

Author Comment

ID: 39202631
 I put # in the format of the form and I can now see the correct number.
 The report is now working correctly.

Thanks so much for your help!

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question