Text box returns the error #Name?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a report in my database with an unbound text box at the top. I
entered the following as the control source:

=[Enter Date Range (e.g. January 1-30, 2006)]

When the date range is entered it returns the value "#Name?"

I have duplicated this in other reports with no problem. In fact this
report worked when I first created it but suddenly stopped working. I even
tried to remedy the problem by copying the text box from one of the working
reports without sucess. Can anyone tell me what might be causing this error?
 
Hi, Lisa,

Try changing the brackets to double quotes.

Sam
I created a report in my database with an unbound text box at the top. I
entered the following as the control source:

=[Enter Date Range (e.g. January 1-30, 2006)]

When the date range is entered it returns the value "#Name?"

I have duplicated this in other reports with no problem. In fact this
report worked when I first created it but suddenly stopped working. I even
tried to remedy the problem by copying the text box from one of the working
reports without sucess. Can anyone tell me what might be causing this error?
 
This didn't work. Access said it was invalid syntax. Any other suggestions?

OfficeDev18 via AccessMonster.com said:
Hi, Lisa,

Try changing the brackets to double quotes.

Sam
I created a report in my database with an unbound text box at the top. I
entered the following as the control source:

=[Enter Date Range (e.g. January 1-30, 2006)]

When the date range is entered it returns the value "#Name?"

I have duplicated this in other reports with no problem. In fact this
report worked when I first created it but suddenly stopped working. I even
tried to remedy the problem by copying the text box from one of the working
reports without sucess. Can anyone tell me what might be causing this error?
 
H'mmm.

Is the unbound textbox's name an Access reserved word, or the name of a valid
field in the form's record source? That would hurt also...

Sam
This didn't work. Access said it was invalid syntax. Any other suggestions?
Hi, Lisa,
[quoted text clipped - 13 lines]
 
Does your report return any records?
By "at the top", do you mean the Report Header or Page Header? Try the
Report Header.
 
The name is Text51 (the default).

I solved the problem already. Thanks for your help though.

OfficeDev18 via AccessMonster.com said:
H'mmm.

Is the unbound textbox's name an Access reserved word, or the name of a valid
field in the form's record source? That would hurt also...

Sam
This didn't work. Access said it was invalid syntax. Any other suggestions?
Hi, Lisa,
[quoted text clipped - 13 lines]
tried to remedy the problem by copying the text box from one of the working
reports without sucess. Can anyone tell me what might be causing this error?
 
That worked! I suspected someone was altering the reports, I just couldn't
figure out what they had done. Now it suddenly makes sense. The text box
was moved from the Report header to the Page header. I moved it back and all
is well.

Thank you very much for your help!

-Lisa

Duane Hookom said:
Does your report return any records?
By "at the top", do you mean the Report Header or Page Header? Try the
Report Header.

--
Duane Hookom
MS Access MVP
--

Lisa said:
I created a report in my database with an unbound text box at the top. I
entered the following as the control source:

=[Enter Date Range (e.g. January 1-30, 2006)]

When the date range is entered it returns the value "#Name?"

I have duplicated this in other reports with no problem. In fact this
report worked when I first created it but suddenly stopped working. I
even
tried to remedy the problem by copying the text box from one of the
working
reports without sucess. Can anyone tell me what might be causing this
error?
 
Back
Top