John,
Thanks for the input. You always there to help me out, that is great. You have no idea how much I apreciate that.
The field is not named "Name", I simply placed it that way for you instead of "Nombre" (spanish) so you had a better idea of what I was talkign about in case you do not know spanish.
I will try and apply that formula you gave me and see what happens, be right back...
Jonathan
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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