If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Input Mask for different control numbers
Input Mask for different control numbers
I use a macro/query to create control numbers (A3341-05-11-XX01) based on differing shop codes --- 3341 3341A A3341 A3341A The control number is broken down like – A – Special type shop 0000 – Department number A – Sections or sub-sets in the department 00 – Year 00 – Month XX – Initials 00 – Sequential records in the same month by the same person. I need an Input Mask that will accommodate all of the shop code formats. If I use ?0000?\-00\-00\-LLCa for 3341 I get spaces where the letter entry is optional. If I use a0000a\-00\-00\-LLCa then 3341 displays as 33410511XX. Any suggestions? |
#2
|
|||
|
|||
Input Mask for different control numbers
KARL DEWEY wrote:
Input Mask for different control numbers I use a macro/query to create control numbers (A3341-05-11-XX01) based on differing shop codes --- 3341 3341A A3341 A3341A The control number is broken down like - A - Special type shop 0000 - Department number A - Sections or sub-sets in the department 00 - Year 00 - Month XX - Initials 00 - Sequential records in the same month by the same person. I need an Input Mask that will accommodate all of the shop code formats. If I use ?0000?\-00\-00\-LLCa for 3341 I get spaces where the letter entry is optional. If I use a0000a\-00\-00\-LLCa then 3341 displays as 33410511XX. Any suggestions? My suggestion would be "Don't use an InputMask". They are evil enough when your data always has the same format. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
Input Mask for different control numbers
I use a macro/query to create control numbers
if the control number is being generated by a macro/query, where is it that you need to use an input mask? do you mean setting the Format property, instead? if you explain the process in some detail, we might be able to come up with a solution that works. hth "KARL DEWEY" wrote in message ... Input Mask for different control numbers I use a macro/query to create control numbers (A3341-05-11-XX01) based on differing shop codes --- 3341 3341A A3341 A3341A The control number is broken down like - A - Special type shop 0000 - Department number A - Sections or sub-sets in the department 00 - Year 00 - Month XX - Initials 00 - Sequential records in the same month by the same person. I need an Input Mask that will accommodate all of the shop code formats. If I use ?0000?\-00\-00\-LLCa for 3341 I get spaces where the letter entry is optional. If I use a0000a\-00\-00\-LLCa then 3341 displays as 33410511XX. Any suggestions? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Syntax error on an input mask that was created by the wizard | Elise | Using Forms | 2 | October 17th, 2005 07:25 PM |
Input Mask creating Problem for Search combo | Rich1234 | Using Forms | 0 | September 28th, 2005 12:08 PM |
Input mask not working for importing | Dion van Overdijk | Database Design | 1 | August 30th, 2005 10:08 PM |
input mask | DrEvil | Running & Setting Up Queries | 5 | May 5th, 2005 02:04 PM |
Input Mask | Loi | New Users | 1 | November 18th, 2004 05:44 PM |