How do I get exclusive rights to the database?

[Guest]

I am just writing a report using Access and have an easy question. I have
concatenated two fields in a expression: field1&". "&field2. field1 is
text, field2 is expanding memo field. They are the name of an item, followed
by the description of an item for a silent auction. Because space in my
program is at a premium, I need the description to follow the item name and
then continue down below the item name.

Is it possible to have field1 in bold font and field2 in normal font? If
not, is there a way to do that?
Thanks for your help and cheers --

 

[Larry Linson]

I am just writing a report using Access and have an easy question. I have
concatenated two fields in a expression: field1&". "&field2. field1 is
text, field2 is expanding memo field. They are the name of an item,
followed
by the description of an item for a silent auction. Because space in my
program is at a premium, I need the description to follow the item name
and
then continue down below the item name.

Is it possible to have field1 in bold font and field2 in normal font? If
not, is there a way to do that?
Thanks for your help and cheers --

Doesn't appear to me to have anything to do with "How do I get exclusive
rights..." per the Subject.

In Access 2003 and earlier, Text Box formatting is for all the data in the
Text Box, so, no, you cannot do what you want with a standard Text Box.
There are ActiveX Controls for displaying "rich text" available... if memory
serves, MVP Stephen Lebans has a free one at http://www.lebans.com; there's
one that used to come with the Office Developer Edition, and a number of
vendors have similar controls. You could use two Text Boxes.

You could also move to Access 2007, in which the Text Box has been enhanced
to have the capability you want.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks, Larry. I wish I had 2007, but the ActiveX controls thing sounds way
too time-consuming. I apologize for the "exclusive rights" detour. I was
having that problem when the concatenation thing seemed more important. I've
not used one of these discussion groups before. I'm a choral director trying
to help my silent auction chairperson. No time to do anything right. Thanks
and cheers --
Liz Barrett