If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
###### in form fields (Access 2007)
Hi all,
I have a problem with field sizes in forms, using Access 2007. One of my applications is used by many users who use Access 2000 upto Access 2007. From one of the Access 2007 users I received the complaint that in several forms, a numerical value is shown as ######. I checked this and found out that with long values, the value is shown as ######. When I click in the field, I see the actual value. When I use the same form and the same data in Access 2000, the right-hand side of the value is shown (as wide as the field allows). So my questions is: how can I modify this, that regardless the length of the value, at least some figures are shown, and not jut ######. Thanks in advance for your advice. Paul |
#2
|
|||
|
|||
###### in form fields (Access 2007)
From Allen Browne's article on 2007:
Option to show numbers as #### if column is too narrow (as Excel does.) Configurable: Office Button | Access Options | Current Database | Check for truncated number fields. I assume you to use this to reverse the process. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200909/1 |
#3
|
|||
|
|||
###### in form fields (Access 2007)
Yes, this solved the problem. Thank you very much,
Paul Op 06-09-09 23:00, Linq Adams via AccessMonster.com schreef: From Allen Browne's article on 2007: Option to show numbers as #### if column is too narrow (as Excel does.) Configurable: Office Button | Access Options | Current Database | Check for truncated number fields. I assume you to use this to reverse the process. |
Thread Tools | |
Display Modes | |
|
|