Little Red Flag to Appear on a Record - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Little Red Flag to Appear on a Record

Jennifer Nield

11 months ago

Hi, just wondering if this is possible.
In our database there is a form for 'Candidate details'. I've created a "Use this Candidate" Yes/No field for the users among all the other information.
What I'd really like, is to have a little red flag appear or emoji if the No has been selected.
Please help.
And even MORE crazy would be nice to have Green, Amber, Red choice if it weren't a Yes/No field.
Too much??

	Kevin Robertson @Reply 11 months ago
I would use an unbound Text Box and control the visibility and colour using VBA code. If you need to display an emoji you can use the Image control instead.

Bill Carver @Reply

11 months ago

I did exactly what kevin is talking about here.
in this case I have a field that is null.  This is tied to another object and test a fird  but you can check the status of your checkbox and use an after update with essentially this in it.

If IsNull(StoredDocumentPath) Then
        clippy.Visible = False
        Else
        clippy.Visible = True
End If

The bad news is that I've brought back clippy

	Bill Carver @Reply 11 months ago

	Jennifer Nield OP @Reply 11 months ago
Jennifer Thanks Kevin and Bill. I've done a few VBA on databases but I'm no expert. Which Event should that go in? 'After Update' or one of those? Or something else?

	Bill Carver @Reply 11 months ago
It does go in after update. It's worth the time to get to know vba and you can do very well here by watching this course which is free. https://599cd.com/blog/display-article.asp?ID=1755 This is an oldie but a goodie specifically about after update https://599cd.com/VideoPlayer/?FN=https://s3.us-east-2.wasabisys.com//Tips/access/afterupdate-event-vba.mp4

	Jennifer Nield OP @Reply 11 months ago
Thank you, I managed it. And thanks for the link, I'll do that now.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View