Hi -
The only thing I can think of is that [PhoneBH] is not a text box. If it
IS a textbox, then I don't know - the code looks fine.
Is [PhoneBH] visible when you execute the code?
Anyone?
It's going to be something obvious, of course!
John
Robin Chapple wrote:
John,
I was missing putting my brain into gear. My apology.
Here is the code behind the option button:
Private Sub BHMobile_AfterUpdate()
Me!PhoneBH.InputMask = "0000\ 000\ 000;0"
End Sub
Thanks,
Robin
On Tue, 12 Sep 2006 20:56:49 -0400, "J. Goddard"
Um, I don't see anything in that code that changes an input mask - am I
missing something?
Are you able to determine which line is causing the error?
John
Robin Chapple wrote:
Thanks John,
Private Sub Form_Current()
Me.LastName.SetFocus
If Me.NewRecord Then
Me!fMobileBHSub.Form![MobileBH].Visible = True
ElseIf Len([PhoneBH] & "") = 0 Then
Me!fMobileBHSub.Form![MobileBH].Visible = True
Else
Me!fMobileBHSub.SetFocus
Me!fMobileBHSub.Form![MemberID].SetFocus
Me!fMobileBHSub.Form![MobileBH].Visible = False
End If
If Not IsNull(Me!fMobileBHSub.Form![MobileBH]) Then
Me.[PhoneBH].Visible = False
End If
End Sub
Cheers,
Robin
On Sat, 09 Sep 2006 21:19:40 -0400, "J. Goddard"
It should support it. Can you post the code that (attempts to)
changes the mask property?
John
Robin Chapple wrote:
In case it is important the full message is:
"Runtime error:
Object does not support this property or method ""
Robin
On Sun, 10 Sep 2006 10:27:27 +1000, Robin Chapple
Thanks Doug,
Error message says:
"Not supported"
Robin
On Sat, 9 Sep 2006 17:24:54 -0400, "Douglas J. Steele"
You can dynamically alter the InputMask property.
Me!MyTextBox.InputMask = "00\ 0000\ 0000;0"
or
Me!MyTextBox.InputMask = "0000\ 000\ 000;0"
in the AfterUpdate property of your option button.