is this possible?????????????????????

[halil]

I need to know how to put an input mask in so that when I write The Road name in an address both names begin with capital letters

e.g

rectory road becomes Rectory Road

 

[Vassago]

Try this:

>#<####################

The > character makes any characters that follow itself become capital letters. The < character has the opposite effect.

Let me know if this information helps.

Vassago

 

[Vassago]

Sorry, the #'s won't work, you will have to specify that it's a letter by using either L or ?.

 

[raskew]

Consider incorporating the StrConv() function. Here are a couple of examples from the debug window.

x = "rectory road"
? StrConv(x,vbProperCase)
Rectory Road
? StrCconv(x,3)
Rectory Road

To find the integer equivalent for vbProperCase, while in the debug window highlight "vbProperCase", click on View > Definition.