Formatting a string within a textbox

[clara]

Hi there,

serveral years' comments have to be merged into one textbox, i would like to
make each year number standingout that might mean some formatting are needed
within an expression. how can i do it

clara

 

[Marshall Barton]

serveral years' comments have to be merged into one textbox, i would like to
make each year number standingout that might mean some formatting are needed
within an expression. how can i do it

The formatting properties apply to the entire text box, not
to parts of it.

How about starting each year's comment on a new line (use
Chr(13) & Chr(10) as the new line sequence. or in VBA the
constant vbCrLf).

 

[Allen Browne]

Clara, just to add to Marshall's comments, the lastest version (Access 2007)
can do this.

More info about the features of the new version:
http://allenbrowne.com/Access2007.html

If this is really important for you, and you can't change to Access 2007,
here are some alternatives:
http://www.lebans.com/mixbold-plain.htm
http://www.lebans.com/richtext.htm