Microsoft Access can't find the field '¦' referred to in your ...

[striker73]

I am running into the error message "Microsoft Access can't find the field '|' referred to in your expression.

My report is tied to my query which contains a field called "Next Due Date". The line of code that the compiler is having trouble with is as follows:

If IsNull([Next Due Date]) OR ([Next Due Date] = "&quot Then
txtGroupHeader = "No date entered"
End If

Any ideas on what the problem is or how I can get around it? Thanks!

 

[KenReay]

Hi

Where is the code (ie which event)

Where are the variables / Controls [Next Due DAte] and txtGroupHeader defined

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[striker73]

The above code is in the GroupHeader0_Format() event. The txtGroupHeader is a textbox on my report. The variable [Next Due Date] is one of the fields in my query that is set as the control source on this report.

 

[striker73]

What's even more frustrating is that I try swapping out the [Next Due Date] code with other fields in my query and it works fine. It's just this one field it has problems with.

 

[KenReay]

Hi

Does [Next Due Date] appear as a control in the GroupHeader section?, if not true putting it there, with visible proeprty set to false



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK