Ask Your Question
0

How to automatically convert case in form fields

asked 2017-04-05 10:47:24 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Is there a method to automatically have the first character of a form field be caps and all other characters entered be lower case? Example; Field name is First Name, if someone enters Joe, joe, JOE or JOe the field would convert it to Joe and store that in the database table.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-04-05 11:20:32 +0200

updated 2017-04-05 11:38:07 +0200

Ciao, you can do in this mode:

If my answer helped you, vote it with ✔ (here on the left)

C:\fakepath\TestCaps.odb

image description

image description

edit flag offensive delete link more

Comments

works well.... how do you automatically convert MR JONES to Mr Jones There doesn't seem to be a s mask for convert caps to lower case, just lower case to caps.

rotormansa gravatar imagerotormansa ( 2017-04-06 13:07:17 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-04-05 10:47:24 +0200

Seen: 28 times

Last updated: Apr 05 '17