Subform datasheet formatting

[andy_dyer]

Hi everyone,

I have a subform in datasheet form three columns;

Project Name, % Complete and Amount Invoiced

Project Name is locked and disabled as this shouldn't be edited...

I would like to show in datasheet view that this column is different to the other two to make it stand out...

Any changes I make seem to affect the whole datasheet - is there a way I can edit just one column and either make the background different or change the font colour or something??

Any ideas??

 

[ajetrumpet]

you cannot do this stuff in datasheet view...(almost SURE). sorry.

 

[Simon_MT]

Andy,

Here's a cheat!

If there is one record on the parent form elevate this information to the Header and then your subform becomes the parent's Detail. Obviously this involves adjusting the Parent's Query.

Or

Access does has conditional formatting but you may have to transform your subform into a Continuous Form that has exactly the same appearance as a datasheet.

Simon

 

[missinglinq]

About the only formatting of this kind you want to do in Datasheet View has to be done using Conditional Formatting.

In Design View select the field/column

Goto Format - Conditional Formatting

Under Condition1 select Expression Is

Then enter

Not IsNull([TextboxName])

Now select the formatting you want

Now, if the field has data in it, it will be formatted.

If you want the field formatted even if it's blank (assuming you're formatting the back color) create another condition

Under Condition2 select Expression Is

Then enter

IsNull([TextboxName])

Select the same formatting as before

Now the field will be formatted with or without data.