A bit of a Masked problem???

[clinton]

Hi Everybody,

I dont want to be a nuisance or pain, I normally squat thru everybook

and resource that I can find,
But I am really stumped on this on, I am building an application for

my own business, and I am trying to figure out how I can create an

account number by lets say masking, the third letter of a clients

firstname and first letter of the clients last name and then adding a

4 digit account number afterwards.

I got the 4 digit code no probs. Problem is the masking...

Can anybody maybe help me out?

A sample of info:

client enters:

firstname: Clinton
Surname : Beetroot
Account no allocated is: 1251 (By application)

I need mask the entered to get "ce1251" Allocated as an account

number?

Any assistance would be greatly appreciated.

I will even send you a copy of the program when I am finished....

Thanks

[Killer42]

Could you provide a little more info about the circumstances? For instance, is this a standalone VB program? (If so, which version?) Is it in Excel? Access? What exactly do you mean about the "masking"? Just concatenating the three things into a string is very simple, but you probably already know that.
For example, given your example...

MaskedValue = Mid$(FirstName,3,1) & Mid$(SurName,1,1) & Format$(AcctNum,"0000")

Incidentally, in your example the generated value should have been "iB1251", not "ce1251". In programming you need to watch those little details or they'll bite you.