Hi all.

I have a custom form in SLX LAN v7.2.1 that the end user enters data in two fields: field1 and field2

I have an OnClick event on the "OK" button that checks to see if one of the 2 fields is missing data. Currently, if one of the fields is blank it pops up a message box telling them the field is blank but when the user clicks the OK on the message box it closes the entire form. Instead I would like for the cursor to be placed in the blank field and the text field be highlighted in a color (i.e. pink).

Any suggestions?

Thank you in advance!

There is an event called AXFomValidate (right click a blank area on form, go to events, choose this one and double-click it. This creates the stub.

In here. Check your conditions. If it fails set AXFormValidate = False - this prevents the form closing. Use myControlName.SetFocus to move back to that control. Use .Colour = adPink (that's not real, you can find those in the color props) to set it to the colour (spelt correctly!) to the one you want.

Thanks worked great!