VBA set Textbox to be required

[Rania01]

Dear all,

How to programatically set Textbox to be required?
If value on Status on the textbox Datum must be required

Thank you in advance

 

[theDBguy]

Is the form bound? If so, it might be easier to just set the field in the table as required. Otherwise, the common approach is to use the form's BeforeUpdate event to validate the form and make sure required fields are entered.

 

[Rania01]

I use textbox unbound, I would like only the Datum must be required if user select value on Status
if on status is empty on the datum not required

Thank you

 

[bastanu]

Look up Access form validation BeforeUpdate as suggested by theDBGuy:

Google Search

Here is the first link:

Perform simple data validation checks when editing a record in a form

Access VBA conceptual documentation

docs.microsoft.com

 

[Gasman]

I use textbox unbound, I would like only the Datum must be required if user select value on Status
if on status is empty on the datum not required

Thank you

Wouldn't it make more sense to have the status first then?

 

[Rania01]

yes of course