Conditional Format Rule triggered then display a help pop-up bubble (1 Viewer)

dd*

New member
Local time
Tomorrow, 02:28
Joined
Nov 17, 2020
Messages
15
If a conditional Format Rule is triggered, I've applied specific text formatting to highlight on the form.

If the conditional Format Rule is triggered can I also display a help pop-up bubble
Is this the Property ControlTip Text.
And how can i do this.

This is currently my Conditional Format Rule with format font applied to text eg

({NoticeNeededYN}<>"")
Then Apply Font Colour Red and Bold
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:28
Joined
May 7, 2009
Messages
19,169
using Current Event will display that, but do you want it to show everytime on each record.

private sub form_current()
If Len(Trim$([NoticeNeededYN] & vbnullstring))=0 Then
msgbox "your message"
end if
end sub
 

dd*

New member
Local time
Tomorrow, 02:28
Joined
Nov 17, 2020
Messages
15
I would like to display the pop-up only on records that meet the Conditional Format Rule.
Is that possible?
TIA
 

missinglinq

AWF VIP
Local time
Today, 11:28
Joined
Jun 20, 2003
Messages
6,423
Is this a Single View, Continuous View or Datasheet View Form?

Linq ;0)>
 

dd*

New member
Local time
Tomorrow, 02:28
Joined
Nov 17, 2020
Messages
15
Display the pop-up only for records that meet the Conditional Formatting.
The form is Continuous View
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:28
Joined
May 7, 2009
Messages
19,169
see post#2 on adding code to the Form's Current event.
 

Users who are viewing this thread

Top Bottom