Format Code

T

TURNIP

Hi I am trying to set up a code so that when values are entered in a form
they are displayed with capital letters at the start of each word for example
a name entered john smith would be viewed as John Smith.

Somebody very kindly sent me the following code to use afterupdate event but
as I am very new to access I am not really sure how to use this can anyone
help?

[FieldName] =strConv([FieldName],3)
 
M

Marshall Barton

TURNIP said:
Hi I am trying to set up a code so that when values are entered in a form
they are displayed with capital letters at the start of each word for example
a name entered john smith would be viewed as John Smith.

Somebody very kindly sent me the following code to use afterupdate event but
as I am very new to access I am not really sure how to use this can anyone
help?

[FieldName] =strConv([FieldName],3)
Click to expand...


First, open the form in design view and select the text box
where you want this to happen. Then display its Properties
sheet (View menu).

Scan down the list of properties under the Events tab until
you find AfterUpdate. Enter [Event Procedure] in the
property and then click on the build button [...] in the
right margin. This will take you to the Visual Basic Editor
with the cursor ready for you to type your line of code.
When you enter the code, enter the name of the text box
instead of "FieldName".
 
Top