Default E-Mail Addresses??

[Carmen]

Don't know if this is possible, but here is what I would like to do....
I have a database with teacher information and classes that they take. All teachers have a school e-mail account and when they register for classes they are required to use their school e-mail account for communication. The format for these addresses is FirstName_LastName@dpsk12.org. I have a text box on my teacher information data entry form for the e-mail address. I would like to figure out some way to have the "@dpsk12.org" part automatically be filled in and the data entry person will only have to enter the FirstName_LastName part. Does this make any sense???? Like I said, I don't know if this is even possible but any help would be appreciated!!

Thanks,
Carmen

 

[Rob.Mills]

Try this:

In the AfterUpdate event of the textbox type this:

Dim str as String

str=Me!TextBoxName.Value

Me!TextBoxName.Value=str & "@dpsk12.org"

 

[Carmen]

Thank you Rob!! Worked like a charm