Mark required fields with a red asterisk

[Stam]

Hello everyone,

I've just registered in this forum and I'd like your support with the following issue.

I've undertaken a rather simple task to build a database app for managing projects.
Some of the table fields have already been marked as required through the fields' properties.
But is there a way to add a red asterisk next to the label of each of these fields in a form?

It's a kinda nice to have feature, instead of having a message showing up.

Many thanks!

/Stam

[June7]

Could use another label with asterisk character and red forecolor.

[Welshgasman]

You could just set the label font to red?
Else I would have thought you would need another label to hold the asterisk so as to be able to have a different colour.

[Stam]

That's what I was thinking as well. Just add a label next to it. But was wondering whether there was a more fancy way to do it, maybe through VBA.
In any case, that will work for sure.

Thank you both for replying!

[pbaldy]

You could also look at Conditional Formatting on the ribbon to add a yellow back color (or whatever) to required controls that aren't completed yet.

[isladogs]

I do exactly what @June7 suggested and bold / colour red the main label caption text for required fields

[CJ_London]

you can use the format property to show a message if the field is null

for text it would be

@;[Red]"Required field"

for numbers

#;#;#;[Red]"Required field"

replace # with whatever number format you require

[Stam]

Many thanks for your answers everyone!
I guess I'll be moving with the extra label as it seems straightforward for the user.

[Welshgasman]

I would expect it depends on how much real estate you have on the form?, else the other options would be better, in my view.

[Stam]

I would expect it depends on how much real estate you have on the form?, else the other options would be better, in my view.

Frankly, there is plenty of info and at the moment I get 10 forms.
Also, a deadline which is soon approaching!

But I might also need some help while building the reports.