Error 2185, 2427, and converted report

D

Darryl

I've converted an Access 97 database to Access 2003.

Several reports are failing, apparently because A2K3 handles the code
below differently than A97. In the report, the first line in
Detail_Format section generates error 2185 can't reference the property
of a control unless the control has focus.

If [SubR: Coverage]![Full Name].Text <> "" Then
lineStrikeOut.Visible = True
[txtBeeper].Visible = False
[txtPhone].Visible = False
Else
lineStrikeOut.Visible = False
[txtBeeper].Visible = True
[txtPhone].Visible = True
End If

Alright, "controls" on a report rarely have focus, at least they didn't
in Access 97, but whatever. However, if I change it to [SubR:
Coverage]![Full Name].Value or to just [SubR: Coverage]![Full Name],
then I get error 2427 You entered an expression that has no value. Yet
IsEmpty([SubR: Coverage]![Full Name] is False and IsNull is false.
[SubR: Coverage]![Full Name] is a field on a subreport in the detail
section.

It says it isn't null, and it isn't empty, but it doesn't want to give
me the text or the value. Any idea what syntax A2K3 might be willing
to accept?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top