How to automatically convert case in form fields [closed]

base

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

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

add a comment

1 Answer

Sort by » oldest newest most voted

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

charlie.it

1722 ●17 ●24 ●44 http://www.charlieopen...

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

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

add a comment

Question Tools

1 follower

Stats

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

Seen: 43 times

Last updated: Apr 05 '17

How to automatically convert case in form fields [closed] edit

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

Comments

Question Tools

Stats

Related questions

How to automatically convert case in form fields [closed]

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