Format Property - need help

  • Thread starter Thread starter Rick A
  • Start date Start date
R

Rick A

Can someone point out to me what's wrong the code below.

This code formats as shown below. It is wrong
Code
Me!txtQualified.Format = ";\PLACED;\NQ;\Null"
From the immediate window
?me!txtqualified.format
;"PLA"c\Ed;\Nq;"Null"

This code formats as shown below. It is right
Code
Me!txtQualified.Format = ";\QUALIFIED;\NQ;\Null"
From the immediate window
?me!txtqualified.format
;"QUALIFIED";"NQ";"Null"


If I change the first code example to be identical to the second in my code
it works as expected. What am I missing.

This is an Access 2000 format mdb that I'm working on in Access 2003.

Thanks,
 
Here's some additional information.

Me!Text1.Format = ";\Qualicfied;\NQ;\Null"

Notice the embeded "c" in Qualified. With the c there a debug.print resutls
in
;"Quali"c"fie"d;\Nq;"Null"

take the "c" out and it shows
;"Qualified";"NQ";"Null" which is what I want. Well I want
;"PLACED";"NQ";"Null" but the c causes the problem.

What the heck does the character "c" have to do with the format property?
 
As weird as it may seem I did this and it worked

me!text1.format = ";\P\L\A\C\E\D;\N\Q"

If anyone know why I had the problem I did I sure would like to know. The
work around, however, is doing the trick

Rick
----------------------------------------------------

Rick A said:
Here's some additional information.

Me!Text1.Format = ";\Qualicfied;\NQ;\Null"

Notice the embeded "c" in Qualified. With the c there a debug.print
resutls in
;"Quali"c"fie"d;\Nq;"Null"

take the "c" out and it shows
;"Qualified";"NQ";"Null" which is what I want. Well I want
;"PLACED";"NQ";"Null" but the c causes the problem.

What the heck does the character "c" have to do with the format property?
Click to expand...
 
Back
Top