Testing First Character of text box for Value

  • Thread starter Thread starter Donnie
  • Start date Start date
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
 
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
 
Back
Top