Change Textbox to Combobox

[waq963]

Hi, I would like to change a textbox into a combobox when checking a checkbox? Thanks

 

[John Big Booty]

I think the only way you can do that is to have both a combo box and text box on your form and change which one is visible as needs be.

Something like the following in the Yes/No's On click event should do the trick

If Me.YourYesNo = True Then
     Me.YourCombo.Visible = True
     Me.YourText.Visible = False
Else
     Me.YourCombo.Visible = False
     Me.YourText.Visible = True
End If

 

[waq963]

Good Idea, nice and easy. Cheers Mate. While i have yout attention do you know how to set a textbox to always allow a value that is less than another. E.g. txtScore is always less than txtMaxScore? Thanks

 

[John Big Booty]

You could do a test in the Before Update event.

It might look something like;

If Me.txtScore.Value > Me.txtMaxScore.Value Then
        MsgBox "please enter a lower value"
        Cancel = True  [COLOR="Green"]' causes the changes to not be saved[/COLOR]
        Undo  [COLOR="Green"]' Resets the value of txtScore[/COLOR]
End If

 

[waq963]

Got that working too. Thanks a bundle mate.

 

[John Big Booty]

Glad to have helped