This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have created a very simple scenario to test the error but I cannot figure out what's wrong.
I have created a table as below
Department Section
HR Admin
I create a Report and create only one text box in the whole report. In the Control Source of the text box, I type =[Section], then it gives #Error in Print Preview
But if I type Section, it gives the result Admin
The name of textbox is renamed as "SectionTxt", so there is no circular reference.
I wonder if Section is a reserved word that caused the problem, any suggestion?
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Section is definitely a reserved word. Forms and reports both have a detail section as well as various header and footer sections.
There are so many reserved words that it's a good idea to avoid using a real word as the name of anything you create. Make the name more descriptive by adding something to it, e.g. DeptSection.
Change =[Section], to Section(remove =[ ] )
If you are not sure then you can always select the control source in the data column/control source row