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
|
|||
|
|||
#error
Generated a report using 'design wizard'. The report reference one of our
tables only. When the field references one of the fields in the table things are ok BUT when I change the reference to '=trim([field name])' I get the #error in the report for that field. We have been here before because we have reports that do the trim thing but don't remember what the fix is. Anyone got any ideas? TIA |
#2
|
|||
|
|||
On Tue, 26 Apr 2005 15:16:29 -0700, mmap wrote:
Generated a report using 'design wizard'. The report reference one of our tables only. When the field references one of the fields in the table things are ok BUT when I change the reference to '=trim([field name])' I get the #error in the report for that field. We have been here before because we have reports that do the trim thing but don't remember what the fix is. Anyone got any ideas? TIA The name of a control cannot be the same as the name of a field in it's controls source expression. Once you add =Trim() to the control source you have created an expression. Change the name of the control to something else, i.e. txtFieldName. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#3
|
|||
|
|||
I forget so soon Tnx.
"fredg" wrote in message . .. On Tue, 26 Apr 2005 15:16:29 -0700, mmap wrote: Generated a report using 'design wizard'. The report reference one of our tables only. When the field references one of the fields in the table things are ok BUT when I change the reference to '=trim([field name])' I get the #error in the report for that field. We have been here before because we have reports that do the trim thing but don't remember what the fix is. Anyone got any ideas? TIA The name of a control cannot be the same as the name of a field in it's controls source expression. Once you add =Trim() to the control source you have created an expression. Change the name of the control to something else, i.e. txtFieldName. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Backing Database | GOL | General Discussion | 4 | January 28th, 2005 03:32 PM |
Error message different in MDB and MDE | david epsom dot com dot au | General Discussion | 1 | September 21st, 2004 12:47 AM |
Help, i'm gettiing error: Access has encountered a problem and needs to close... | betsy | General Discussion | 0 | September 14th, 2004 08:20 PM |
Expression - calculating running total | Kathy | Running & Setting Up Queries | 26 | June 22nd, 2004 10:14 PM |
Custom Error Messages | DMc2004 | Database Design | 4 | June 11th, 2004 11:16 PM |