Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Access 2010  table field looks different in the linked table

Posted on 2013-05-28
3
Medium Priority
?
446 Views
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?
 Help?  
Thanks,
   Donna
Backend-db.docx
0
Comment
Question by:abcctech
  • 2
3 Comments
 
LVL 59

Accepted Solution

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

  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.

Jim.
0
 

Author Comment

by:abcctech
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,
   Donna
0
 

Author Comment

by:abcctech
ID: 39202631
Jim,
 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!
   Donna
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

581 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