Access -- Using input mask as delimiter

[kfcSmitty]

I am using an input mask to display my information as "99/99".

When I display the contents of the textbox it appears as "1003" instead of "10/03". It also saves it this way to the database. I am trying to use the split function to break it up into 2 seperate numbers IE 10 and 03 so I can save it into the database as "10/03".

The user can also enter the values as 10/3 or 1/1 or any variation, so I cannot simply split it per 2 digits.


Does anyone know how to either save a textbox to a database including the mask, or does anyone know how to split the textbox contents by the delimiter?


Thanks,
kfcSmitty

[DKenny]

The following code will split the value in your testbox based on the position of the forward slash.


Private Sub Text8_AfterUpdate()
Dim MasterString As String
Dim SubString1 As String
Dim SubString2 As String

MasterString = Me.Text8

'First check if the field has a forward slash
If InStr(1, MasterString, "/") = 0 Then
Me.Text8 = ""
Exit Sub
End If

'Then Set the two substrings to the values to the left and right of the forward slash
SubString1 = Left(MasterString, InStr(1, MasterString, "/") - 1)
SubString2 = Mid(MasterString, InStr(1, MasterString, "/") + 1)

'Just to prove that it works
'replace this with your code
MsgBox SubString1
MsgBox SubString2
End Sub

[dannymking]

You could also use the split function to populate the data into an array..


Dim Values() As String
If Instr(textbox1,"/") > 0 Then
Values = Split(textbox1,"/")
Msgbox Values(0)
Msgbox Values(1)
End If


However, you may be better off placing the imput mask on the text box and the relevant field in the table below to

00/00

This will force data entry in the format of two digits followed by "/" and then two digits, if this is not entered then the user will receive a message to this affect