Lele Brown
asked on
Access report controls list
Is there any way to see all of the controls/text boxes/labels and a report - even ones that may be hidden from view or covered by another control in design view?
I have a report that gets an error on run saying that The Microsoft Access database engine does not recognize 'C' as a valid field name or expression. I changed a few of the text box values from [C] or [P] to something else. I have checked every text or label box that I can see on the report and there is not a C anywhere.
Thanks
I have a report that gets an error on run saying that The Microsoft Access database engine does not recognize 'C' as a valid field name or expression. I changed a few of the text box values from [C] or [P] to something else. I have checked every text or label box that I can see on the report and there is not a C anywhere.
Thanks
Dale Fye
Check in the report Sort and Group section. You may have defined a sort or Group that uses that field.
ASKER
The Sort and Group section was grouped on a field that started with a C. I changed it to something else to just test and got the same error.
I did find by right clicking on a text box and then going into the control source that i can see all controls on the report. There is no C there either.
I did find by right clicking on a text box and then going into the control source that i can see all controls on the report. There is no C there either.
Do you have any code behind the report, or in the code that opens the report?
You may need to put a breakpoint in the code that opens the report, and step through that process. Even that may not help you find it.
Did it specifically state [C] (with the brackets)?
You might consider getting Rick Fishers Find and Replace utility. It will search everywhere in an Access file for a string (not sure about data, have never tried that). I believe it has a trial period, but it is well worth the cost.
You may need to put a breakpoint in the code that opens the report, and step through that process. Even that may not help you find it.
Did it specifically state [C] (with the brackets)?
You might consider getting Rick Fishers Find and Replace utility. It will search everywhere in an Access file for a string (not sure about data, have never tried that). I believe it has a trial period, but it is well worth the cost.
ASKER
There is no code behind except
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Cancel = IsNull(Me.DISPLAY)
End Sub
The report did use [C] but the error message refers to 'C'. I thought when the [] is used, that meant it was a user defined field on a form/report or in a query. The text fields have formulas in them such as sum([P] + [C]). When I try to change them to the new values from the query bound to form, I go into build of text box data control, click on the query but no query values come up. The query is a crosstab so that may be an issue.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Cancel = IsNull(Me.DISPLAY)
End Sub
The report did use [C] but the error message refers to 'C'. I thought when the [] is used, that meant it was a user defined field on a form/report or in a query. The text fields have formulas in them such as sum([P] + [C]). When I try to change them to the new values from the query bound to form, I go into build of text box data control, click on the query but no query values come up. The query is a crosstab so that may be an issue.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thanks