Highlight row in subform

[Graeme at Raptup]

Hi,
I want to highlight the 'active' row in a subform.
Frustrating thing is that I did this about a year ago and can't seem to
figure where I'm going wrong!
I have the conditional formatting as prepared by Stephan Lebans.
I've pretty much taken the modules and pasted them onto my db.
I'm looking at highlighting in datasheet view so have these modules:
clsConditionalFormattingDataSheetView
modConditionalFormatting
modGetCurrentRow
I have added the txtbackground field to the subform and have changed the
reference of 'txtcustomerid' to my forms reference which is 'QuoteID'.

When opening the form I get this message:
Compile Error
Method or data mamber not found

Cursor is at CF.BGTextBox = Me.txtbackground

Any help appreciated.

Graeme

 

[SusanV]

You've defined the controls, but not what properties of the controls you
want to set (Me.Textbox.backcolor, rather than Me.textbox)

 

[Graeme at Raptup]

Hi Susan,
not sure if I'm with you.
Script in module reads:

CF.BGTextBox = Me.txtbackground

' Set the desired Highlight Color
CF.HighlightColor = CLng(vbRed)
End Sub

Or do I have to select all the controls and change the properties (on the
form)?
If so, what properties do I change?

Cheers,

Graeme

 

[SusanV]

Sorry Graeme, I'm not familiar with the code your trying to work into your
project - normally one sets a text box's background color as I outlined
(Me.MyTextBox.Backcolor = vbRed) I'm not sure how that code is running, or
what CF. references. Hope I haven't confused you more...

=(

 

[Graeme at Raptup]

Hi,
I figured this out.
Therefore just closing the thread.

Cheers