Re: Forms - Mandatory field

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Brendan Reynolds (brenreyn)
Date: 01/23/05

  • Next message: Ted: "Re: Forms - Mandatory field" 
    Date: Sun, 23 Jan 2005 21:22:46 -0000

    In the BeforeUpdate event of the form ...

    If (Me![FieldA]) Then
        If Len(Trim$(Me![FieldB])) = 0 Then
            MsgBox "Uh-huh"
            Cancel = True
        End If
    End If 

    -- 
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
"Ted" <ted@nospam.com> wrote in message 
news:wfUId.771$fy.736@newsfe6-gui.ntli.net...
> Hello,
>
> I have 2 fields on a form... FieldA and FieldB.
>
> FieldA is a Yes / No box
> FieldB is a Date field
>
> Both fields are not 'required' at table level.
>
> What I want to be able to do is make data-entry into FieldB mandatory, 
> only
> IF FieldA = "yes".
>
> Any help / advice would be appreciated.
>
> Ted
>
>
>
>
>
  • Next message: Ted: "Re: Forms - Mandatory field"

    Relevant Pages

    • Re: insert variables into Query
      ... Learning SQL and Access ... from tableX ... fieldA <= tableY.EndDate ... fieldB>= tableY.EndDate ...
      (microsoft.public.access.queries)
    • Re: constraint in Trigger
      ... CREATE TRIGGER tiu_name ON tblName ... IF (@FieldB IS NOT NULL) AND (@FieldA IS NULL) ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
      (comp.databases.ms-sqlserver)
    • Re: insert variables into Query
      ... on the date in your [EndDate] field? ... fieldA <= tableY.EndDate ... fieldB>= tableY.EndDate ... SQL iteration 1: ...
      (microsoft.public.access.queries)
    • Re: Limit Report to the 1st 30 records
      ... ORDER BY FieldC Desc, FieldA, FieldB ... In the sort row, of a Blank column in my existing query ...
      (microsoft.public.access.reports)
    • Re: Percentage at group level of Crystal Report.
      ... FieldC is a formula field, dividing FieldA by FieldB. ... > as to how to create a group level value for FieldC, ...
      (microsoft.public.vb.crystal)