Text box returns the error #Name?

[Lisa]

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?

 

[OfficeDev18 via AccessMonster.com]

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?

 

[Lisa]

This didn't work. Access said it was invalid syntax. Any other suggestions?

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?

 

[OfficeDev18 via AccessMonster.com]

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]

 

[Duane Hookom]

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

 

[Lisa]

The name is Text51 (the default).

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

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?

 

[Lisa]

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

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
--

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?