Need Input Mask for a textbox

F

FA

Hi Freinds,
I have a field FINDG_NO in my sql server that has datatype Varchar. Its
a Primary Key of the table.
On my Access form called frmFinding i have a text box called
txtFindingNo in which user will input the Finding No.

The finding Numbers are in the following format
Five charachters in the begining then today's date and three
alphanumerics at the end.
Sample Finding No: ABCDE01/06/06K75

Is there anyway i can define the input mask for the text box
txtFindingNO so that it shows five fillers "_" in the begining then
automatically today's date and three filler "_" in the end.
something like this : _ _ _ _ _ 01/06/06_ _ _

If there is a VBA code for this functionality please let me know or if
i can do something in the input mask please folks do let me know.

Thanks bunch

Moe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking and populating text box between two forms 0
Input Mask for General Date/Time 1
Need VBA Codes for a Huge Problem in MS Access 1
Date input mask 1
Properties - Format, Input Mask, Validation Rule 5
changing the Phone Number Input Mask to all for extensions 2
europe date format / input mask 1
Input Mask oddity - BUG? 7

Top