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
|
|||
|
|||
#Name? in text field
If I use:
DoCmd.OpenReport Reportname, acViewPreview I get #Name in a text field both on the screen and on the print out. If I use: DoCmd.OpenReport Reportname, acViewNormal I do get the field to print correctly. I want the user to be able to view the printout before going to the printer so the first option above is what I am looking for. Please help Thank You! |
#2
|
|||
|
|||
#Name? in text field
Open the report in design view.
Right-click the problem text box, and choose Properties. What is in the Control Source property? It sounds like Access is having problems identifying the field or the items in the expression. Also check the Name property. If the control has the same name as a field, but it bound to something else, Access gets confused. The fact that it works in normal view but not if you preview suggests there could be other possible issues as well, such as data types being misunderstood, or code that is not working as expected, or a Name AutoCorrect issue. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Amour" wrote in message ... If I use: DoCmd.OpenReport Reportname, acViewPreview I get #Name in a text field both on the screen and on the print out. If I use: DoCmd.OpenReport Reportname, acViewNormal I do get the field to print correctly. I want the user to be able to view the printout before going to the printer so the first option above is what I am looking for. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Edit/Add record in form from cmdButton | doodle | General Discussion | 3 | December 28th, 2005 03:06 AM |
Word applies direct format on File open | Uriel | General Discussion | 16 | November 27th, 2005 07:22 PM |
Creating dynamic cross reference links in a Word document | torajudo | General Discussion | 4 | October 25th, 2005 03:51 PM |
Ideas On Producing Envelopes & Labels For Data | RNUSZ@OKDPS | Setting Up & Running Reports | 0 | April 28th, 2005 03:22 PM |
Combo Box (1st) Populating Text Box (2nd) Field | AccessRookie | Using Forms | 1 | April 6th, 2005 11:37 PM |