Adding a TON of text to a report

[nanscombe]

=DLookUp("TCVersion","TermsAndConditions","ID=1") & " updated on " & DLookUp("TCVersionDate","TermsAndConditions","ID=1")

The "[" and "]" tell it to prompt for parameters.

You should also be able to use & vbCRLF & to add a carriage return if required.

 

[Mihail]

Look like you spelling something wrong.
If you have
1) a table/query named TermsAndConditions
2) two fields in this table named TCVersion respectively TCVersionDate
3) another field in this table named (as simple as I see) ID
should work.
Is TermsAndConditions a table or a query ?
What parameter Access is asking for ?

 

[Mihail]

Ups. Sorry. I don't see that parentheses. I see only the second "=".

 

[RIck5150]

Once you concatenate fields, is there any way to get the date format to LONG DATE instead of SHORT DATE which seems to be the default? If not, I can certainly live with this. Thank you everyone for your help.

 

[nanscombe]

You could use the Format() function.

 & Format(DLookup(....) ,"Long Date")

More info about formatting dates in Format the date and time field in Access

 

[RIck5150]

Would that be like this?

& Format (DLookUp("TCVersion","TermsAndConditions","ID=1") & " updated on " & DLookUp("TCVersionDate","TermsAndConditions","ID=1") ,"Long Date")

 

[nanscombe]

No. Just around the date part.

=DLookUp("TCVersion","TermsAndConditions","ID=1") & " updated on " & Format(DLookUp("TCVersionDate","TermsAndConditions","ID=1"), "Long Date")

 

[RIck5150]

Haha, that explains a lot. Thank you again for all of your help.