Input Mask

[Guest]

Hello. I am trying to create an input mask of the following:
060131SB01

Here is what the numbers and letter represent:

06=Year
01=Month
31=Day
SB=CityName (it could be SB, SM or LO)
01= Batch Number ( It could be any number 01 through 50, the single numbers
need a leading zero i.e. 01 02 03....

Could you please help? Your help would be greatly appreciated.

Thanks.
Iram/mcp

 

[Rick B]

Generally, you would not want to do this. Each field in a database should
contain one piece of information. In my opinion, this is three fields...

RecordDate
CityName
BatchNumber


You can then take these three fields and display them in the format you
mention on your forms, reports, and queries by formatting and concatenating
the three fields.

=Format([RecordDate],"YYMMDD") & CityName & BatchNumber

 

[Graham Mandeno]

Hi Iram

You could use an input mask such as 000000LL00.

However, this would allow *any* digits and letters, so "123456WW99" would be
valid.

You would also need to use a BeforeUpdate event procedure to parse the
different parts and check them for validity.

 

[Guest]

Thanks guys. I am probably going to use the "000000LL00" only because this
field is the Primary Key. I really did like the idea of the concating and I
can use it for another issue that I need to fix.

Thanks.
Iram/mcp

Hi Iram

You could use an input mask such as 000000LL00.

However, this would allow *any* digits and letters, so "123456WW99" would be
valid.

You would also need to use a BeforeUpdate event procedure to parse the
different parts and check them for validity.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hello. I am trying to create an input mask of the following:
060131SB01

Here is what the numbers and letter represent:

06=Year
01=Month
31=Day
SB=CityName (it could be SB, SM or LO)
01= Batch Number ( It could be any number 01 through 50, the single
numbers
need a leading zero i.e. 01 02 03....

Could you please help? Your help would be greatly appreciated.

Thanks.
Iram/mcp

 

[Guest]

Again thanks.

How can I put "back slashes" and "dashes" in the mix i.e. 06\02\08-SB-01 ?

Thanks.
Iram\mcp.

Hi Iram

You could use an input mask such as 000000LL00.

However, this would allow *any* digits and letters, so "123456WW99" would be
valid.

You would also need to use a BeforeUpdate event procedure to parse the
different parts and check them for validity.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hello. I am trying to create an input mask of the following:
060131SB01

Here is what the numbers and letter represent:

06=Year
01=Month
31=Day
SB=CityName (it could be SB, SM or LO)
01= Batch Number ( It could be any number 01 through 50, the single
numbers
need a leading zero i.e. 01 02 03....

Could you please help? Your help would be greatly appreciated.

Thanks.
Iram/mcp

 

[John Spencer]

I think that would be the following input mask.

00\\00\\00\-LL\-00

For a nice discussion, try putting the cursor in the Input mask property and
pressing the F1 key - you should get the help page for this.

Again thanks.

How can I put "back slashes" and "dashes" in the mix i.e. 06\02\08-SB-01
?

Thanks.
Iram\mcp.

Hi Iram

You could use an input mask such as 000000LL00.

However, this would allow *any* digits and letters, so "123456WW99" would
be
valid.

You would also need to use a BeforeUpdate event procedure to parse the
different parts and check them for validity.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hello. I am trying to create an input mask of the following:
060131SB01

Here is what the numbers and letter represent:

06=Year
01=Month
31=Day
SB=CityName (it could be SB, SM or LO)
01= Batch Number ( It could be any number 01 through 50, the single
numbers
need a leading zero i.e. 01 02 03....

Could you please help? Your help would be greatly appreciated.

Thanks.
Iram/mcp

 

[Guest]

It worked. Thanks a million John.

Iram/mcp.

I think that would be the following input mask.

00\\00\\00\-LL\-00

For a nice discussion, try putting the cursor in the Input mask property and
pressing the F1 key - you should get the help page for this.

Again thanks.

How can I put "back slashes" and "dashes" in the mix i.e. 06\02\08-SB-01
?

Thanks.
Iram\mcp.

Hi Iram

You could use an input mask such as 000000LL00.

However, this would allow *any* digits and letters, so "123456WW99" would
be
valid.

You would also need to use a BeforeUpdate event procedure to parse the
different parts and check them for validity.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hello. I am trying to create an input mask of the following:
060131SB01

Here is what the numbers and letter represent:

06=Year
01=Month
31=Day
SB=CityName (it could be SB, SM or LO)
01= Batch Number ( It could be any number 01 through 50, the single
numbers
need a leading zero i.e. 01 02 03....

Could you please help? Your help would be greatly appreciated.

Thanks.
Iram/mcp