Does anybody know how can I get the information that is being from an online form to my Access database to come out in ALL CAPS.

Or is there a function in Access that converts the info in the field to all caps?

Thank you.

When ur updating or inserting into the database via ASP you can convert the data from the form to uppercase then use the <b>ucase()</b> function:

Dim sName
sName = request.form("name"
rs("name" = <b>UCase(sName)</b>
rs.update

so no matter what the user enters in the textfield 'name' it will be inserted into your database as ALL CAPS.

Hope this helps!

********************
wheatNOTmeat<b></b><b></b>

Edited by - Ferox101 on 25 Sep 2002 11:46:47

will add it to my code.

thank you!

I was trying to post the asp code to my page, but I can't seem to find the right location to put it. Reason being because DW MW made a MM_editAction function and can't find the proper location.

(hope it makes sense)

Any help would greatly be appreciated.

Could anybody tell me where I should insert this code in my document? Or is there an easier way to do this?

Thank you.