Am trying to have the email addresses for my 'Users' table auto create per the format that this customer uses. Of course everyone does things differently!

I created radio buttons for these options:

1. <firstname><lastname>

2. <lastname><firstname>

3. <firstinitial><lastname>

4. <firstname>

5. <lastname>

6. <initials>

Am not sure where to start on the If/Then script. Want the applicable result of the radio button selection to pull the appropriate format of the name fields & append them to the customer's &"@"&<domain name>. The result of course will be their proper email address.

Anyone done this yet, or have any ideas?

Kent Barnard, MCSE(NT/2K Gold)/CCNA/CCEA

ACS, Inc. (Macon, Georgia)

You could create a calc (text) field to deliver the required email address combination - from your radio button field. In the following example, the radio button field is called "NameOption" and the choices are 1 to 6.

Substitute(Substitute(

Case(

NameOption = 1, FirstName & LastName & "@" & DomainName,

NameOption = 2, lastName & FirstName & "@" & DomainName,

NameOption = 3, Left(FirstName,1) & LastName & "@" & DomainName,

NameOption = 4, FirstName & "@" & DomainName,

NameOption = 5, LastName & "@" & DomainName,

NameOption = 6, Left(FirstName,1) & Left(LastName,1) & "@" & DomainName,

"Error")," ",""),"P","")

where the P in the last line is the backwards paragraph thingo. The substitute parts of the calc will eliminate any spaces and carriage returns from the email address. If the user has not provided a name, then you will get "Error" in the email address - so you can easily do a Find for that.

Russ: Outstanding! Your solution worked without a hitch. Appreciate your time & energy.

KB