check box formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm creating a form in Access 2000, and I have a check box labeled 'To Be
Determined'. I need two fields (Buyer/Borrower1 and Co-Buyer/Borrower) to be
automatically filled with the words TO BE DETERMINED if the check box is
checked, then if the check box is unchecked, I need those fields to be blank
so a name can be typed in manually.

I'm a novice and have tried dozens of variations of after update events, but
when it doesn't work, I don't know which part I've done incorrectly.
(spacing, quotation marks, bracket style, etc.).

Secondly, I have every field on my form formatted so that it is highlighted
in a different color when it has focus, so the user can see at a glance where
they are on the form. But my check boxes don't give me that option, and when
they have focus, you can't find where on the form you are. Any solutions to
this?
 
In the After Update event of the check box and in the form's Current event:
Call FillBorrowerFields

Then in the General section of your form module:
Sub FillBorrowerFields
If Me.MyCheckbox Then
Me.Borrower1 = "TO BE DETERMINED"
Me.Borrower2 = "TO BE DETERMINED"
Else
Me.Borrower1 = ""
Me.Borrower2 = ""
End If
End Sub

Unfortunately, the check box does not have a back color property. The best
you can do is set your border properties so that attention is drawn to it,
and/or change the special effects property.
 
You might think about putting some error checking in here that looks to see
if an entry exists in the fields first. If there are already entries, do
you want to wipe them out with the new words? What if they click it by
mistake.

Just a suggestion.
 
Back
Top