Results 1 to 8 of 8
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Include fields in Report Text box

    Does anyone know how to include fields in a report text box? I don't want two different boxes...

    For example..

    I have a textbox which has legal jargon..

    I, [CONSUMER NAME], hereby authorize Woody's Lounge to be the greatest forum on the planet.

    Any way to do this?

    Thanks!

    D
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Include fields in Report Text box

    Drk:

    You can set the Control Source of the text box to be:

    ="I, " & [CONSUMER NAME] & ", hereby authorize Woody's Lounge... "

    This should do the trick!
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Include fields in Report Text box

    It doesn't like this...

    Error:
    Extra ) in query expression '"I," & [=Trim([FirstName]. . .

    ="I," & [=Trim([FirstName] & " " & [MiddleName] & " " & [LastName] ) ] & "hereby authorize Woodys Lounge to be the best lounge on the planet any time after" & [DateAfter] & "." & "My King of the world Number is" & [KingofworldNumber] & "."

    What's wrong with this picture?

    Drk.
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  4. #4
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Include fields in Report Text box

    Drk:

    I think that the offending bit is the brackets around your Trim statement and the "=" within:

    ="I," & [=Trim([FirstName] & " " & [MiddleName] & " " & [LastName] ) ]

    Try the following:

    ="I," & Trim([FirstName] & " " & [MiddleName] & " " & [LastName]) & "hereby authorize Woodys Lounge to be the best lounge on the planet any time after" & [DateAfter] & "." & "My King of the world Number is" & [KingofworldNumber] & "."

    If that doesn't do the trick, you might try trimming each of the pieces of the full name seperately, i.e. Trim([FirstName]) & " " & Trim([MiddleName]), yadda. Lemme know if this works out...
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Include fields in Report Text box

    Okay.. that work..

    Now.. <img src=/S/devil.gif border=0 width=15 height=15> Is there a way to replace DateAfter with "________" if DateAfter is blank?

    Thanks!

    Drk.
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  6. #6
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Include fields in Report Text box

    You might try an Immediate If construct to hold the expression for that part of the string.

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Include fields in Report Text box

    If the field is actually null, you can use the Nz function, i.e., Nz([DateAfter],"_________"). However, date/time fields are tricky, so test it.
    Charlotte

  8. #8
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Include fields in Report Text box

    That works!

    Thanks!

    Drk.
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •