Testing First Character of text box for Value

D

Donnie

This is in regard to a form that adds assigns a barcode number and
creates a new file. I need to write some VBA code that will take a
look at the clientID text box and see if it begins with a 0 (zero).
If so, I need to place a coordinating zero at the beginning of another
text box field called barcode. FYI, the zero is being stripped off
because when I generage the barcode, I take the clientID then add
10000, and add the year of the file. In the process of doing this
math, a preceding zero will get stripped off.

If you know of the complete solution to this problem, or a part of it
please let me know. Thank you.

Donnie
 
D

Donnie

John,

Thanks for your help. After digging around for a while the other day,
I did come up with the same solution you just offered. The reason I
didn't post my code was because most of the barcode was actually being
generated using macros (i'm just now starting to lean more towards
vba).

Thanks again for taking the time to respond. Also, if you know a good
reference website for Access VBA commands, that would be most helpful
in learning VBA coding for Access. Thanks.

Donnie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top