Setup field required in the forms

[a.phoenix]

I need to set required some field in the forms. I know I can do it in the property of table, but that field will affect to another from too.




So, can I use the macros or modules to fix it?


Please, tell me how to do it. I don't have so much experience with macro and modules.


Thank you
Prakan.P

[Welshgasman]

Most people would put a value in the Tag property of the controls, let's say R, and then check for that tag and whether that control has a value and is valid.

https://www.google.com/search?q=acce...hrome&ie=UTF-8

[Edgar]

Validate your form entries with the BeforeUpdate event of the form if you're editing a record and BeforeInsert if you're adding a new record. Do you know how to do that?

[a.phoenix]

Thanks for your answer.

Absolutely Not, I know the basics of access to create the table, forms, report command and little about macros.

and if it not so much I wonder if I set the table to required = Yes, can I use macros or modules for the massage warning example

I have field status and in property of this field in the table I choose required = Yes. I found the error warning is not friendly to user understanding. If I want to change warning like "please choose the status" how to do it?

[a.phoenix]

Thanks for your answer.

[a.phoenix]

Validate your form entries with the BeforeUpdate event of the form if you're editing a record and BeforeInsert if you're adding a new record. Do you know how to do that?

Thanks for your answer.

Absolutely Not, I know the basics of access to create the table, forms, report command and little about macros.

and if it not so much I wonder if I set the table to required = Yes, can I use macros or modules for the massage warning example

I have field status and in property of this field in the table I choose required = Yes. I found the error warning is not friendly to user understanding. If I want to change warning like "please choose the status" how to do it?

[Edgar]

Add this to your form's code

Private Sub Form_BeforeUpdate(Cancel As Integer)
    If IsNull(Me.status) Then
        Cancel = True
        MsgBox "Please choose the status"
    End If
End Sub

Change me.status with the name of the control you want to make sure has been filled.

As for your table field being required, that's up to you, I don't remember if you can modify the message. With this form code, the user won't be able to add or modify records if that control is empty, additionally, you can customize the message.

[Micron]

If there are more than 3 controls I'd probably use the tag approach mentioned in post 2 rather than have a sub for every one of them since the number of controls needing this sometimes grows as things change. The worst part of the multi sub approach is that one usually codes to exit if a required field has no value. User fixes that and tries to save again only to encounter another annoying prompt. I avoid that by listing all of them at once in one message box. I also like to ensure that the labels for these controls are attached. That way, I can get the descriptive text for the field (e.g. First Name) from the label rather than the name of the control (e.g. txtFName). However, I would have that situation because I never allow a field and control to have the same name, and the field names are often shortened since they only need to make sense to me.

@a.phoenix, if you want some code that handles all this, I should be able to find it in my archives. You would need to add a tag - e.g. Reqd (no quotes) to the tag property for those controls that require this validation. Also best to limit the search in the code to only the type(s) of controls you've done this for so you'd need to define that in a post.

[mike60smart]

Hi
The attached gives some examples of using the Tag

[a.phoenix]

Thanks you very much.

Add this to your form's code

Private Sub Form_BeforeUpdate(Cancel As Integer)
    If IsNull(Me.status) Then
        Cancel = True
        MsgBox "Please choose the status"
    End If
End Sub

Change me.status with the name of the control you want to make sure has been filled.

As for your table field being required, that's up to you, I don't remember if you can modify the message. With this form code, the user won't be able to add or modify records if that control is empty, additionally, you can customize the message.