How do I fix error #name? in acc2003 page numbering

[Guest]

I am trying to Insert page numbers on a Access Form, however I get the error
#name? on the form, I have tried searching for a solution, but found nothing
relivent, I am using the standard expression/control source - ="Page " &
[Page] & " of " & [Pages] - Can Anyone Help

 

[Keith Wilby]

I am trying to Insert page numbers on a Access Form, however I get the
error
#name? on the form, I have tried searching for a solution, but found
nothing
relivent, I am using the standard expression/control source - ="Page " &
[Page] & " of " & [Pages] - Can Anyone Help

Put two hidden text boxes on the report, one with a control source "Page",
the other "Pages".

HTH - Keith.
www.keithwilby.com

 

[Guest]

I added the text boxes and hid them ...
Unfortunaly I Still Get the Same error #Name?

I am trying to Insert page numbers on a Access Form, however I get the
error
#name? on the form, I have tried searching for a solution, but found
nothing
relivent, I am using the standard expression/control source - ="Page " &
[Page] & " of " & [Pages] - Can Anyone Help

Put two hidden text boxes on the report, one with a control source "Page",
the other "Pages".

HTH - Keith.
www.keithwilby.com

 

[Keith Wilby]

I added the text boxes and hid them ...
Unfortunaly I Still Get the Same error #Name?

Try replacing the text box with a new one from the *toolbox*. I've noticed
that if you modify the control source of a text box that was created by
dragging from the query/table field names that this can sometimes happen,
although I don't know why.

Regards,
Keith.

 

[Guest]

Unfortunatly I am still getting the same error, even with new text boxes...
Have you any other ideas ???

 

[Keith Wilby]

I've noticed that if you modify the control source of a text box that was
created by dragging from the query/table field names that this can
sometimes happen, although I don't know why.

Actually I think I've just sussed it. It appears to be a problem if a text
box has the same name as its data source. Try prefixing your text box names
with "txt".

Keith.

 

[Keith Wilby]

I am trying to Insert page numbers on a Access Form,

Nick, I've just had one of my "duh" moments. I've been giving you the
solution for report page numbering, sorry - I've just tried it and you don't
need the hidden text boxes. Your problem might be the text box names, try
using the "txt" prefix I mentioned earlier.

Keith.

 

[Keith Wilby]

Unfortunatly I am still getting the same error, even with new text
boxes...
Have you any other ideas ???

Are you sure you've got the text box in the *page* footer? You can't number
a form in the form footer AFAIK. You'd see the page number in print preview
mode with the text box in the page footer.

Keith.