K
KezKez
Guest
I was wondering if anyone could point me in the right direction..
I'm working on a database for work
there are a million things giving me a headache (I've attended two 1 day courses but haven't a clue
)but one little thing that is annoying me is a problem I have with input masks..
In my Contacts table, I have First Name, Surname, Company, etc..
I've made the first letter of the first name and surname have a capital letter ie;
FIRST NAME
Field Size: 20
Format: *Is clear*
Input Mask: >L<CCCCCCCCCCCCCCCCCCC
SURNAME
Field Size: 20
Format: *Is clear*
Input Mask: >L<CCCCCCCCCCCCCCCCCCC
COMPANY
Field Size: 30
Format: *Is clear*
Input Mask: >L<CCCCCCCCCCCCCCCCCCCCCCCCCCCCC
I have a problem in that, usually company names contain more than one word plus PLC or LIMITED at the end.. I want to be able to make each word start with a capital but as the lengths vary, I don't know where to put these in the input masks
Any help? I'm sure it's easy but I don't know
I'm working on a database for work


In my Contacts table, I have First Name, Surname, Company, etc..
I've made the first letter of the first name and surname have a capital letter ie;
FIRST NAME
Field Size: 20
Format: *Is clear*
Input Mask: >L<CCCCCCCCCCCCCCCCCCC
SURNAME
Field Size: 20
Format: *Is clear*
Input Mask: >L<CCCCCCCCCCCCCCCCCCC
COMPANY
Field Size: 30
Format: *Is clear*
Input Mask: >L<CCCCCCCCCCCCCCCCCCCCCCCCCCCCC
I have a problem in that, usually company names contain more than one word plus PLC or LIMITED at the end.. I want to be able to make each word start with a capital but as the lengths vary, I don't know where to put these in the input masks


Any help? I'm sure it's easy but I don't know
