Subform Datasheet Format Colour of Cell?

[All_At_Sea]

Hi,

I'm trying to have the colour of one of my cells in a Datasheet a different colour. In this particular case have the Life Expiry Date in Red.

I've tried changing the Fore Color to Red and it is then Red when I view it in Layout View, but not when in Datasheet View or when it is displayed in my Form, as the example below where I'd like the Life Expiry Date 31 Oct 24 to be in Red.



Any ideas on how I can achieve it, if at all possible?

Cheers

 

[Micron]

Datasheets are the least format-able type of form and you're pretty much restricted to having all datasheets looking the same as per application settings for datasheets. This will include tables and queries.

You probably should switch to a continuous form. If you really need it to look like a datasheet you can do that. There is only one of any type of control on a continuous form, so what you do to it affects all instances. If you need special formatting in particular row(s) based on field value you use conditional formatting.

 

[All_At_Sea]

Many thanks @Micron for the reply, information and confirmation that it's not possible.

The information is better suited to being displayed in a datasheet, so I'll just have to live without.

 

[Micron]

As mentioned, a continuous form can be made to look like a data sheet. I spent a few minutes throwing this together as an example of that so it may not be perfect.

 

[Micron]

...and here is a date field with CF in that same form

 

[welshgasman]

This is a datasheet and CF for ID > 10

 

[welshgasman]

Here is the date control set

 

[Micron]

WGM, can you do that for one field in one record? The ask was for "one cell". I never asked for clarification in this thread but thought as much. Seems that I confused this one with the one at AccesszzForums.net

Regardless, I suspect it has been dropped.

 

[welshgasman]

I was reading it as an Excel user using Excel speak?
You and I know it would be every record for that control, as shown in the pics, unless some criteria was applied.
As usual, not a great example to start with.

 

[Micron]

You and I know it would be every record for that contro

I thought as much when I gave my original answer but it's one of those things that are becoming distant memories and I was not 100% positive.
There's also the fact that I've turned off updates for Access, believing "if it ain't broke..."