Change font formatting for part of a field in a report

[Amy E. Baggott]

I am trying to turn a letter into an Access report because some of the
records in the query are near-duplicates except for two pieces of data in
each one, which need to print as a list. The only problem is that in the
text of the letter, there is some text (the name of the show) that needs to
be bolded and also a url that should be underlined. How do I get this to
work in Access 2003 and still have it look like a letter? Failing that, how
do I get the data into Word and set the letter up so that I have one letter
for each person, with the booth and target date as a list?

 

[Duane Hookom]

If I understand correctly, you have multiple "booth/target" records for you
main record. There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. One of
the samples concatenates multiple child records together with a tab
character between the fields and delimited with a CrLf.

 

[Amy E. Baggott]

Will this help me turn it into a single record for a Word Merge? The letter
is formatted this way

yada, yada, yada. Your login and password are below:

Login: ------
Password: -----

Your move-in Target Dates are:

Booth Date
Booth Date
etc.

yada, yada, yada

where the booth(s) and date(s) show up as a table ranging from one to eight
lines (I don't think anyone has more booths than that). Is there some way I
can use crosstabs or something to turn those records into booth1, date1,
booth2, date2, etc. fields? Would that be a better solution?

--
Amy E. Baggott

"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson

If I understand correctly, you have multiple "booth/target" records for you
main record. There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. One of
the samples concatenates multiple child records together with a tab
character between the fields and delimited with a CrLf.

 

[Duane Hookom]

Yes, the concatenate function will build a field value that contains
information from multiple child records.

--
Duane Hookom
MS Access MVP

Will this help me turn it into a single record for a Word Merge? The
letter
is formatted this way

yada, yada, yada. Your login and password are below:

Login: ------
Password: -----

Your move-in Target Dates are:

Booth Date
Booth Date
etc.

yada, yada, yada

where the booth(s) and date(s) show up as a table ranging from one to
eight
lines (I don't think anyone has more booths than that). Is there some
way I
can use crosstabs or something to turn those records into booth1, date1,
booth2, date2, etc. fields? Would that be a better solution?