Re: Frustrating ampersand problem with label on report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Tue, 20 Jun 2006 17:07:14 GMT, Tony M <tmokonen@xxxxxxxxx> wrote:

Hello. I have a report with a multiline label. I am using the
Detail_Format event to assign a value to the label's caption in code.

If I set the label's caption to:
FAS Hake - #1 Pacific Hake, H&&T<vbcrlf>
FAS Hake - #1 Pacific Hake, H&&T, IQF<vbcrlf>
FAS Hake - #2 Pacific Hake, H&&T

the label prints:
FAS Hake - #1 Pacific Hake, H&T
FAS Hake - #1 Pacific Hake, H&T, IQF
FAS Hake - #2 Pacific Hake, H&&


Even more strangely, if I assign
FAS Hake - #1 Pacific Hake, H&T<vbcrlf>
FAS Hake - #1 Pacific Hake, H&T, IQF<vbcrlf>
FAS Hake - #2 Pacific Hake, H&T

to the label, it prints:
FAS Hake - #1 Pacific Hake, HT
FAS Hake - #1 Pacific Hake, HT, IQF
FAS Hake - #2 Pacific Hake, H&T

If I only assign two lines to the label, everything is ok, the label
only gets scrambled when it has 3 or more lines.

Any ideas on why my report is misbehaving the way it is?

Tony

Never mind, after googling the groups, I found that this is a bug in
Access. Whenever 3 or more ampersands appear in a label, the label
will do funny things with the last ampersand. I guess I'll have to
use a text box instead of a label.

Tony
.