Hi folks,

We have a need to replace sub strings in certain message text.  We use
the Office Assistant to display help and often use the imbedded
formatting commands.  Those of you who have used them know they look
like this: "{cf 5}" or "{cf 0}" or "{ul 1}" or "{ul 0}", etc.  The
commonality they have is that they are always 6 charters long and
always begin and end with curly brackets.

This all works great if the user is running the retail version of
Access.  Unfortunately, some of our users run Access Runtime -- in
which case the code simply writes the same message text (including the
imbedded formatting strings) to a standard form window.  Of course, we
do this because. for some inexplicable reason, Microsoft will not
include Office Assistant functionality when an Access app is running
with Access Runtime.

So, we need to pre-process the message text for Runtime users and
remove all of the formatting strings.  Here is what we have tried:

lblTxt1 = Replace(lblTxt1, "{", "", , 6, vbBinaryCompare)

OR,

lblTxt1 = Replace(lblTxt1, "{", "", , 6, vbTextCompare)

OR,

lblTxt1 = Replace(lblTxt1, "{????}")

NONE of these approaches work.  Is there any way to use pattern
matching in combination with the Replace function?

I am praying that I won't be forced to use brute force Instr functions
to remove these formatting strings at runtime.

Any suggestions?

Thanks,

-- LW