Text box

J

JimmyTheDog

Using VB I check a string for length, if the length is 10 characters I
concactenate the character A. If the length is 11, I use Right(string,1) to
retrieve the letter and then I use Asc to determine ascii value. I add 1 to
the value and convert is back to a letter with ChB. I then concactenate this
value to 10 character string which is numeric. The field length is 20
characters and text. There is no formatting applied in the properties,
basically default. When the textbox receives the string it only accepts the
10 characters. I can type in the 11 apha character. I've checked the value
of the string before "textbox.text = str" and the 11 characters are there.
I've tried this on two different forms with the same result.
 
G

Graham R Seach

....and your question is?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
J

JimmyTheDog

Figured this out on Sunday, my problem was using ChrB when I should have used
just Chr. With ChrB the string appeared to be what I wanted, however the
format was wrong. Thanks for the reply.
 
Top