Lower Case Text Field

[ebbo]

Hello,

I have made a form based on a query. The Field in question is called FTP_account.

The form is tabular showing a list of all FTP accounts.

I would like the data shown in the text box FTP_account to be shown in lower case only. At the moment it displays a mixture of lower or upper depending on how it was entered into the database by the person who setup the account.

I have googled and found the following code.....but my problem is which event should this go in.....I cant seem to get it to work...is this correct?

FTP_username.Text = LCase(FTP_username.Text)

Is anyone able to help me on this simple query?

 

[ajetrumpet]

use the after update event of the box. either that, or use input mask symbols that signify lowercase entries.

 

[ebbo]

use the after update event of the box. either that, or use input mask symbols that signify lowercase entries.

It does not work when placed in the After Update event.. I still see Capital Letters in some rows.

 

[ajetrumpet]

It does not work when placed in the After Update event.. I still see Capital Letters in some rows.

upload the db and i'll fix it for you if you want