Formatting in Forms
 

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?

Formatting in Forms
 

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?

Formatting in Forms
 

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?