I have an unbound textbox in the my Form Header (named txtCurrentRecord). In my Current event for the form I have this : Me.txtCurrentRecord.Value = Me.ID and the current record's ID is displayed in the box.
I also have a textbox that is "sent to the back", Visible=False, Enabled=False, Locked=True and has a light gray background that covers the record. Note that is unbound on a continuous form, so any attempt I try to make visible/invisible applies to every record.
If I use something like this in the txtBackground Control Source : =IIf([ID]=[txtCurrentRecord],-1,0) is displays -1 in the current record and 0 for the rest of them on the form.
I am trying to get something like this to work : =IIf([ID]=[txtCurrentRecord], [txtBackground].Visible =True, [txtBackground].Visible =False), but it doesn't appear to work w/properties, only text.
I know the problems with unbound controls on continuous forms, and I don't have anything in the recordsource that would allow me to query on to determine if it's current or not or highlight for some other reason.
Is there any workaround to simply "highlight" the current record when using a continuous form ?