Access 2000 textbox control question

A

Ann Marie Bette

Hi,
I was wondering if anyone can help me with formulating
syntax to automatically build an email address on a form?
I work at a school district and everyone's e-mail address
is made up of lastname, first initial of first name and
@xyzschool.us

If I have a form that has a field for lastname as well as
firstname I thought I could save my users from entering
an email address. I need to attach a function to my e-
mail field textbox control but I am not sure what the
syntax is. I was looking up information on the String and
Left functions. Somehow I would imagine I need to use a
combination of both but I'm afraid I am not sure how. Any
help is greatly appreciated. Many thanks in advance for
your assistance with this matter.
Ann Marie Bette
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top