How to automatically convert case in form fields

base

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

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

add a comment

1 Answer

Sort by » oldest newest most voted

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

charlie.it

1192 ●13 ●22 ●43 http://www.charlieopen...

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

edit flag offensive delete link

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 ( 2017-04-06 13:07:17 +0200 )edit

add a comment

Question Tools

1 follower

Stats

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

Seen: 32 times

Last updated: Apr 05 '17

How to automatically convert case in form fields edit

1 Answer

Comments

Question Tools

Stats

Related questions

How to automatically convert case in form fields