input mask not moving to table 1

[JaredTaylor74]

hello..

i have a txtbox on an unbound form i want various input masks on, depending what was selected in a few previous lstboxes. i have my input mask strings in a table, i call those on the after update of the last lstbox. the correct input mask is in the txtbox. not a problem.

my problem is this...
because there are various input masks i can't set the field in my table to a static input mask.
once the form is complete, the user clicks a button and it open a recordset to add the data entered to the table. it adds it just fine, but the input mask doesn't follow it.

here are some examples:
MoldToolType MoldTypeInputMask
ARBURG MOLDSET 00-00
ARBURG SLIDE "00-000""A""/0B"
ARBURG SHUTTLE 000

here is my code:

Set rstMoldingHardware = DBEngine(0)(0).OpenRecordset("SELECT * from tblListMoldingHardware")
    With rstMoldingHardware
        .AddNew
        ![MoldPartNumber] = Me![txtNewPartNumber]
        ![MoldPartType] = Me![lstPartType].Value
        ![MoldMachineCompatability] = Me![lstMoldType].Value       
        .Update
        .Close
    End With

for example the user enters an ARBURG SLIDE partnumber "15-061A/1B" they enter it just fine on the form (they don't type the - or the A or B, it's already there). but when it sends it to the table, the data that is sent is only the data they typed. "150611"

i want the data they don't type to be in the table too... how can i do that? (trying to send it to "MoldPartNumber")

Thanks,
Jared

 

[PHV]

Use MoldTypeInputMask & ";0" for the TextBox's inputmask.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JaredTaylor74]

RIGHT ON!!! YOU ARE THE MAN!!!

THANK YOU. WORKS GREAT!!

Jared

 

[shannonp]

hrmmmm, I'm stumped...but perhaps try changing say the the ARBURG SLIDE data type to Number (Double) and then use the following input mask: 00\-000"A"/0"B.

I tried every possible scenario and still can't seem to emulate your problem, but would have to say its a formatting issue and not how the data is stored.


Shann