Brugervenlig fejlmeddelelse

Hi Trine
Try validation rule for the field.

Did you receive the dB I sent yesterday?

Hi Terry :-), yes but why validation rule, I don't want to validate data, I just want the user to write something in the field, that's why I have set the Required property to True.
And yes thank you, and I replied on it at 11.45 in the evening yesterday.

Hi Trine
No, but you want to make sure that the user has entered a value (required) and if you dont take action then Access will. Ot maybe I'm misunderstanding your problem!

Yes I can see you have answered my mail, dont get those at work! I'll take a look this evening once I've had something to eat :o)

Hi Terry, no I don't think you have misunderstood my problem, I have just always been thinking that Validation rule was something else than Required. I thought Validation rule was to validate on data, that the user had to enter data in a certain way. What I want here is for the user to enter his or her initials, like xxx or ter, and also I need the field to be filled in with something, because I use it in a searchform, where I need for the field not to be empty, otherwise the record will not show on my searchform, so what you're saying is that if I make a validation rule for the field AND the required property set to True, I can pick my own validation text as my brugervenlige fejlmeddelelse?

Hej - Jeg har lig lavet et par stykker til mine formularer

De felter som brugeren SKAL udfylde er gule
På formularens vedFejl hændelse ligger jef følgende kode:

Private Sub Form_Error(DataErr As Integer, Response As Integer)
    Select Case DataErr
        Case 3314
            MsgBox "De gule felter skal udfyldes", vbCritical
            Response = acDataErrContinue
        Case Else
            Response = acDataErrDisplay
    End Select
End Sub

Niels

Hej Niels, det var sådan set lige det jeg var ude efter. Tak for det. Mvh. Trine

>Niels smid et svar så jeg kan "pointere" dig.

svar