Can you set a forced format within forms? (i.e. state = 2 alpha, capital)
When someone enters ca it will change to CA or title case verses caps for
data entry?

Amy
What do you mean by "within forms"? You could use a Worksheet_Change
macro. The code you would write in the macro could look at some specific
range, like a specific column, and change any entry to caps. Is that what
you need? HTH Otto
"Amy" wrote in message
...
Can you set a forced format within forms? (i.e. state = 2 alpha, capital)
When someone enters ca it will change to CA or title case verses caps for
data entry?

I'm trying (1st attempt) to create a form that will be easier to populate for
a client rather than gonig through 29 or columns and then back to column A to
start the next line. In doing this, some of the fields are address related
and phone related, so I was wondering if the person puts spells out the State
rather than two letter abbreviation, the form would not except it or
populate. Does that make since?

"Otto Moehrbach" wrote:

Amy
What do you mean by "within forms"? You could use a Worksheet_Change
macro. The code you would write in the macro could look at some specific
range, like a specific column, and change any entry to caps. Is that what
you need? HTH Otto
"Amy" wrote in message
...
Can you set a forced format within forms? (i.e. state = 2 alpha, capital)
When someone enters ca it will change to CA or title case verses caps for
data entry?