Help with Microsoft Access

[sean_churchill]

Hi, I trying to do some kind of formula to work out the following thing: -

Highlight a particular piece of data when it has been six months before it was last checked? so when it is over six months the data is highlighted (which is a name of a company)

Any suggest would be great.

Many Thanks

Sean.

 

[Dugantrain]

Where are you trying to do this? In a form, table, query, report? It shouldn't be too hard to do in a report or form, but I'm not sure if it's possible to highlight line items in tables or queries

 

[sean_churchill]

i am trying to do this in a form.

any suggestions?

Cheers.

sean.

 

[Dugantrain]

I assume that you're viewing this data with several text boxes, one of which is for company name and one of which is the date? If this is true then this code should work:

Private Sub Form_Current()
Me.yourcompanynametextbox.FontBold = False
If me.yourdatetextbox< "##/##/####" Then
Me.yourcompanynametextbox.FontBold = True
End If
End Sub

This will get you up and running. Of course, the way this is set up, your cutoff date would always be the same. You'd have to pass in an argument in order to have this be dynamic and change as you're moving forward.

 

[sean_churchill]

Thanks for your help.

Much appreciated!

Sean.

 

[sean_churchill]

Thanks for your help.

Much appreciated!

Sean.