W
WK
Hi,
In ACCESS 2003 (it doesn't matter whether as original or with SP1 or SP2) I
deteced two very curious errors. To my knowledge these errors do not appear
with ACCESS 2000.
Both error occur within labels. When I want to have a "&"-char within labels
I have to double them within the design mode. Then "&" will be corrctly
displayed within the formular mode.
a) Error by 2nd use of "&"-sign
When I enter the string "ABC && DEF" in the design mode this will be
correctly displayed in the formular mode. But when I enter "ABC && DEF &&
GHI" in the design mode the result in formular mode is "ABC & DEF &_GHI".
Is there a possibility to supress the display of the "_"-sign?
b) Error by 3nd use of "&"-sign
This error is much "better"
. When I enter in a label field the string
"ABC && DEF && GHI
& JKL" the result in the formular mode is "ABC && DEF && GHI & JKK". Thus
the last character will be ignored and the second last character of this
string will be doubled.
These errors occur independently whether you enter these strings directly in
the design mode or whether you use VBA to send this string into the label
field.
Has anyone an idea how to avoid both errors? Any help is appreciated.
Best regards,
Winfried
In ACCESS 2003 (it doesn't matter whether as original or with SP1 or SP2) I
deteced two very curious errors. To my knowledge these errors do not appear
with ACCESS 2000.
Both error occur within labels. When I want to have a "&"-char within labels
I have to double them within the design mode. Then "&" will be corrctly
displayed within the formular mode.
a) Error by 2nd use of "&"-sign
When I enter the string "ABC && DEF" in the design mode this will be
correctly displayed in the formular mode. But when I enter "ABC && DEF &&
GHI" in the design mode the result in formular mode is "ABC & DEF &_GHI".
Is there a possibility to supress the display of the "_"-sign?
b) Error by 3nd use of "&"-sign
This error is much "better"
. When I enter in a label field the string"ABC && DEF && GHI
& JKL" the result in the formular mode is "ABC && DEF && GHI & JKK". Thus
the last character will be ignored and the second last character of this
string will be doubled.
These errors occur independently whether you enter these strings directly in
the design mode or whether you use VBA to send this string into the label
field.
Has anyone an idea how to avoid both errors? Any help is appreciated.
Best regards,
Winfried