Re: An easy one for you VB / Access guru's

Do you know what the trigger should be? i.e. when you scroll down is there
a
property on your scroll window that changes?! Not sure about access as i
am
a dbase man but if you can find that trigger then the code should be
easy...

on event(scrolllist.trigger)
    if text1.text <> text2.text
    text1.backcolor = &H000000FF&

Hope that helps

chris

"Robin Lewis" <agent@[EMAIL PROTECTED]
> wrote in message
news:1h4s10p945qfdkfeip9s32rbpf0v420hj9@[EMAIL PROTECTED]
> I have a simple Access database set up and a form and I need to compare
two textboxes,
> 'email1' and 'email2', on the form.
>
> If the two textboxes do NOT match I need to change the background colour
of 'email1' to
> RED to bring this to my attention.
>
> This needs to change on a 'per record' basis, so as I scroll through the
records using the
> standard 'next' and 'previous' buttons I can quickly see which ones are
and are not
> matched!
>
> Can anyone submit some code for me as I have NO idea at all!
>
> PS this needs to work directly in Access and not a standalone VB
frontend!
>
>