Include fields in Report Text box

Topic

New Reply

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

Reply | Quote

Replies

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!

Reply | Quote

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.

Reply | Quote

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…

Reply | Quote

Okay.. that work..

Now.. Is there a way to replace DateAfter with “________” if DateAfter is blank?

Thanks!

Drk.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

That works!

Thanks!

Drk.

Reply | Quote