A little help needed with Input Masks..

  • Thread starter Thread starter KezKez
  • Start date Start date
K

KezKez

Guest
I was wondering if anyone could point me in the right direction..

I'm working on a database for work :eek: there are a million things giving me a headache (I've attended two 1 day courses but haven't a clue :rolleyes: )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 :confused: :o

Any help? I'm sure it's easy but I don't know :o
 
You shouldn't use input masks on the table as you'll probably want to use Forms to allow the users to input data into the table. With that being said, this would probably be something you'll want to do with VBA instead of using input masks on the form. You could create a module that will cycle through the string of characters typed and check the casing of the string. Search the forum first as this question comes up quite often and samples of code have been given on how to accomplish this using VBA on a form.
 

Users who are viewing this thread

Back
Top Bottom