Ask Your Question
0

How to automatically convert case in form fields [closed]

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

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-29 12:53:19.448249

1 Answer

Sort by » oldest newest most voted
0

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

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

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 +0100 )edit

Question Tools

1 follower

Stats

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

Seen: 43 times

Last updated: Apr 05 '17