Formatting Access Fields in Queries

[chegra26]

I have the below expression in an access query. How can I bold only [TenantsName]?

Lease1: " This Short Term Rental Agreement (the “Agreement”) is made by and between Agrati Consulting, LLC (“Homeowner”) and" & " " & [TenantsName] & " " & "(“Guest”) as of the date last set forth on the signature page of this Agreement. For good and valuable consideration, the sufficiency of which is acknowledged, the parties hereby agree as follows:"

Thank you
Michelle

 

[Joe4]

You don't.
Queries are not meant to be used for presenting data, they are meant to select data sets/do calculations. As such, they really do not have much in the way of formatting options.
Data is typically presented in Forms or Reports, and that is where you will find the formatting options.

 

[HiTechCoach]

I agree with Joe that you should do as much formatting as possible on a form or report.

Data is best stored in tables NOT formatted. Queries collect data from tale(s). Forms and reports have controls that support formatting.


If you are using Access 2007 and later you can use the new built-in RichText feature to bold text.

EDIT: I tried to post example code but I can't figure out how to get it to show HTML tags.