Formatting in Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
Back
Top