Trim Expression

[FranD]

I put a control on a report that simply concatenates the values of two fields (Division and Section). Here's what I have
=Trim([Division]&" - "&[Section])
It returns #Error. I think the problem is the name of the field - "Section". I experimented by replacing the Section field with another field in the report and it worked fine. Short of renaming this field is there any quick fix??

Thanks

 

[simongallop]

Try using the full pathname of the field ie [TableName]![Section]

 

[Travis]

Is it possible that [Section] is:

1. Mispelled
2. A Null Value {USE NZ([SECTION],"")}
3. Not Part of the Recordset

 

[Pat Hartman]

Open the properties sheet for the control. On the "Other" tab, change the control "Name" to something other than the name of a field in the recordsource.

 

[SteveA]

Section is a reserved word for Access Reports. The Report Header, Page Header, Detail etc are all considered sections within an Access report. Using a different name for your field should resolve this issue.

SteveA

 

[FranD]

Thanks Steve,
Changing the name was indeed the only thing that worked. Are there other Access names that are not good to use as field names? If so, where can I get a list of them?

Thanks again.

Fran