need help

you can try generating the username by getting the first name and second name and then processing it character by character?

Use VB's Left function to return the first character, and the Split function to split the username into first and last names.

Or, to use the methods Phil suggested...

Dim txName as string
dim sSplit() as string
dim sUserID as string

txName = "Phil Weber"
sSplit = split(txname, " ")
sUserID = left$(ssplit(0)) & ssplit(1)

'sUserID now contains "PWeber"

BW, MascalLineas, you have a couple of variants in your code.

dim txFirst, txSecond, txResult as string

returns txFirst and txSecond as a variant, and txResult as a string.

If you want all three to be strings, you need to do this:

dim txFirst as string, txSecond as string, txResult as string

No problem... I could write up a one liner too... but it's easier to explain (as you pointed out) in pieces.

I was just making you aware of the fact that declaring multiple variables on one line requires you to type EACH VARIABLE, or they end up as variants (and variants are evil :) )