IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Theory and Practice of Programming Forum / MS Access question
Post #333,222
by jbrabeck
9/27/10 12:00:43 PM
Reply
New MS Access question
I am trying to get multiple & to display in a text box, without success.

Here's what I'm trying to display:
AADMNN&QUAL..PS060D09.PP&PP.&CY.BU

The way I understand it I should enter:
AADMNN&&QUAL..PS060D09.PP&&PP.&&CY.BU

However that results in:

AADMNN&QUAL..PS060D09.PP&PP.&CY.BB (note last character changed to 2nd last character)

What am I doing wrong?

MS Access 2003, SP3

TIA,
Joe
Post #333,260
by jay
9/27/10 10:03:44 PM
Reply
New As far as I know that should work
As far as I know that should work. For some reason it isn't picking up the double && on the one entry. I would try putting three & in there and see what happens.

I would also try copying the code into a text file, deleting it out of access and recreating it. I have not seen this on code, but I have seen cases where access's internal representation and the typed string got out of sync on queries.

One work around you can try is using chr(38) to add it directly.

Jay
Post #333,264
by beepster
9/27/10 10:57:23 PM
Reply
New I thought so too
was wondering if it was not taking on of the ampersands as an operator (in error)
Sure, understanding today's complex world of the future is a little like having bees live in your head. But...there they are.
Post #333,374
by scoenye
9/29/10 4:48:13 PM
Reply
New Text box or label?
Assigning the string with the single &s (i.e. the one that looks like the desired end result) to a text box works just fine.

Me!Text0 = "AADMNN&QUAL..PS060D09.PP&PP.&CY.BU" produces exactly what you entered.

A label is something else... what you are running into seems to be an Access 2003 bug. It works as advertised on 2000 and 97.

You could use a locked text box as a workaround... even saves the hassle of escaping all the ampersands.

     MS Access question - (jbrabeck) - (3) - Sept. 27, 2010, 12:00:43 PM EDT
         As far as I know that should work - (jay) - (1) - Sept. 27, 2010, 10:03:44 PM EDT
             I thought so too - (beepster) - Sept. 27, 2010, 10:57:23 PM EDT
         Text box or label? - (scoenye) - Sept. 29, 2010, 04:48:13 PM EDT

Urine is turned into bouyancy.
63 ms