format fields within a textbox

[Lungta]

Does anyone know how to format (italics in this case) a specific field value
within a string in a text box?

Example - Control source for textbox txtPar1:
=("I, " &[DriverName]&", operating under the Company Name " &[BusCo]&",
agree to comply with the requirements of the " &[Law1]&" "&[Law2]&" .")

I'm putting all this in one textbox because the length of [DriverName] and
[BusCo] can vary a lot and it has to look seamless. But the two laws cited
have to be in italics. Is there a way to specify font italic format for just
those 2 fields (kind of like you format dates & currency)? Or is there a Vba
way to do what I'm trying?

Any possibilities are welcome! Thanks.

 

[Allen Browne]

The text box in Access is not capable of formatting some of the text
differently to the other.

You could download a rich text box such as this one:
http://www.lebans.com/richtext.htm

FYI, Access 2007 will have this capability built-in when it is released next
year.

 

[Lungta]

Thanks for the reply, Allen! Sorry for the delay in answering, I'm having a
heck of a time signing on to this news group - takes over an hour sometimes
but mostly just fails. Maybe it's a high traffic time over the weekend.

We are on a super-locked-down environment and can't install ActiveX controls
at all. Basically it seems like my choices are probably to:

(1) change the report/contract so the variable-length names are on a
separate line in separate textboxes, like:
txt1 =("I, "&[DriverName]&"operating.....etc")
new line: txt2 =("agree to comply with ") txt3 [Law1] txt4 ("and ") txt5
[Law2];
or
(2) go back to bookmarks in Word, but still haven't figured out how to merge
multiple records per contract yet.

Thanks very much for your assistance - I would have hacked at it way too
long if you hadn't informed me it was impossible.

p.s. how does a person get the little green checkmark to go on a message?
There's no yes/no buttons like the Help file suggests (or else maybe I'm
missing something obvious...?)

Thanks again!
--
Lungta

The text box in Access is not capable of formatting some of the text
differently to the other.

You could download a rich text box such as this one:
http://www.lebans.com/richtext.htm

FYI, Access 2007 will have this capability built-in when it is released next
year.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Does anyone know how to format (italics in this case) a specific field
value
within a string in a text box?

Example - Control source for textbox txtPar1:
=("I, " &[DriverName]&", operating under the Company Name " &[BusCo]&",
agree to comply with the requirements of the " &[Law1]&" "&[Law2]&" .")

I'm putting all this in one textbox because the length of [DriverName] and
[BusCo] can vary a lot and it has to look seamless. But the two laws
cited
have to be in italics. Is there a way to specify font italic format for
just
those 2 fields (kind of like you format dates & currency)? Or is there a
Vba
way to do what I'm trying?

Any possibilities are welcome! Thanks.

 

[Allen Browne]

Hi Lungta

Sorry to hear you had such difficulities accessing this newsgroup.

I don't use the web interface. If you are able to configure your own email
(may not be possible in your corporate environment), you can use Outlook
Express (the freebie that comes with Windows) to use these groups.

To read email, open OE, and go to:
Tools | Accounts | Add | News
Enter a display name, and click Next.
Enter a fake email address (so you don't get spamed).
For the NNTP server, enter news.microsoft.com

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for the reply, Allen! Sorry for the delay in answering, I'm having
a
heck of a time signing on to this news group - takes over an hour
sometimes
but mostly just fails. Maybe it's a high traffic time over the weekend.

We are on a super-locked-down environment and can't install ActiveX
controls
at all. Basically it seems like my choices are probably to:

(1) change the report/contract so the variable-length names are on a
separate line in separate textboxes, like:
txt1 =("I, "&[DriverName]&"operating.....etc")
new line: txt2 =("agree to comply with ") txt3 [Law1] txt4 ("and ")
txt5
[Law2];
or
(2) go back to bookmarks in Word, but still haven't figured out how to
merge
multiple records per contract yet.

Thanks very much for your assistance - I would have hacked at it way too
long if you hadn't informed me it was impossible.

p.s. how does a person get the little green checkmark to go on a message?
There's no yes/no buttons like the Help file suggests (or else maybe I'm
missing something obvious...?)

Thanks again!
--
Lungta

The text box in Access is not capable of formatting some of the text
differently to the other.

You could download a rich text box such as this one:
http://www.lebans.com/richtext.htm

FYI, Access 2007 will have this capability built-in when it is released
next
year.

Does anyone know how to format (italics in this case) a specific field
value
within a string in a text box?

Example - Control source for textbox txtPar1:
=("I, " &[DriverName]&", operating under the Company Name " &[BusCo]&",
agree to comply with the requirements of the " &[Law1]&" "&[Law2]&" .")

I'm putting all this in one textbox because the length of [DriverName]
and
[BusCo] can vary a lot and it has to look seamless. But the two laws
cited
have to be in italics. Is there a way to specify font italic format
for
just
those 2 fields (kind of like you format dates & currency)? Or is there
a
Vba
way to do what I'm trying?

Any possibilities are welcome! Thanks.

 

[Lungta]

Thanks, Allen. The help centre has been looking into it, also and they have
been really great. But I'll try that Outlook Express connection you
mentioned.

Cheers!
--
Lungta

Hi Lungta

Sorry to hear you had such difficulities accessing this newsgroup.

I don't use the web interface. If you are able to configure your own email
(may not be possible in your corporate environment), you can use Outlook
Express (the freebie that comes with Windows) to use these groups.

To read email, open OE, and go to:
Tools | Accounts | Add | News
Enter a display name, and click Next.
Enter a fake email address (so you don't get spamed).
For the NNTP server, enter news.microsoft.com

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for the reply, Allen! Sorry for the delay in answering, I'm having
a
heck of a time signing on to this news group - takes over an hour
sometimes
but mostly just fails. Maybe it's a high traffic time over the weekend.

We are on a super-locked-down environment and can't install ActiveX
controls
at all. Basically it seems like my choices are probably to:

(1) change the report/contract so the variable-length names are on a
separate line in separate textboxes, like:
txt1 =("I, "&[DriverName]&"operating.....etc")
new line: txt2 =("agree to comply with ") txt3 [Law1] txt4 ("and ")
txt5
[Law2];
or
(2) go back to bookmarks in Word, but still haven't figured out how to
merge
multiple records per contract yet.

Thanks very much for your assistance - I would have hacked at it way too
long if you hadn't informed me it was impossible.

p.s. how does a person get the little green checkmark to go on a message?
There's no yes/no buttons like the Help file suggests (or else maybe I'm
missing something obvious...?)

Thanks again!
--
Lungta

The text box in Access is not capable of formatting some of the text
differently to the other.

You could download a rich text box such as this one:
http://www.lebans.com/richtext.htm

FYI, Access 2007 will have this capability built-in when it is released
next
year.

Does anyone know how to format (italics in this case) a specific field
value
within a string in a text box?

Example - Control source for textbox txtPar1:
=("I, " &[DriverName]&", operating under the Company Name " &[BusCo]&",
agree to comply with the requirements of the " &[Law1]&" "&[Law2]&" .")

I'm putting all this in one textbox because the length of [DriverName]
and
[BusCo] can vary a lot and it has to look seamless. But the two laws
cited
have to be in italics. Is there a way to specify font italic format
for
just
those 2 fields (kind of like you format dates & currency)? Or is there
a
Vba
way to do what I'm trying?

Any possibilities are welcome! Thanks.