Dear jrv2110 (name?)-
That might be because the field contains a zero-length string. Try this:
IIf(Len([Name] & "") = 0, "Name:____________", "")
By the way, Name is a reserved word in Access. You should not give any field
that name.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jrv2110
Sent: Tuesday, May 24, 2011 10:04 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Subform return error
I have a subreport that has a client's email address(es). I want a formula that
will return in the a text box in the main report a note saying the following:
"Please provide your email:_______________"
I am using a formula in the main report with data on that main report (not on a
subform) and it is working great:
=IIf([NAME] Is Null,"Name:_____________","")
The name of the subreport is: Report.SUBRPT CORREO ELECTRONICO
The name of the field within the subreport is: CORREO ELECTRONICO
"Is null" is not working because when the Email subreport has nothing in it,
there is nothing that happens with the formula.
Thanks in advance for any advice.
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar