Formatting in Forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amy - 07 Mar 2007 18:49 GMT

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?

Reply to this Message

Otto Moehrbach - 08 Mar 2007 02:20 GMT

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

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

Reply to this Message

Amy - 08 Mar 2007 20:32 GMT

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?

> Amy
> What do you mean by "within forms"? You could use a Worksheet_Change
[quoted text clipped - 4 lines]
> > When someone enters ca it will change to CA or title case verses caps for
> > data entry?

Reply to this Message