Microsoft Access 2010 subform formatting with datasheet view

I am creating an input form for a client and they want the subform to display highlighting if a record has one price different by x percent from another price. I want the subform to display multiple records at a time and the only way I have found to do that is with datasheet view. I have tried to change formats with VBA but it is not working.

Thanks!

Microsoft Access

Last Comment

Phil

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Bill Ross

5/14/2013

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Phil

5/14/2013

ASKER

Hi Bill, thanks. Will this work on a subform?

Gustav Brock

5/14/2013

> I have tried to change formats with VBA but it is not working.

That's because it is ignored in datasheetview.
You have to use conditional formatting in this case.

/gustav

Bill Ross

5/14/2013

Hi,

Yes. You can design the subform separately and the changes will be available in the main form when the subform is viewed.

Regards,

Bill

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

William Peck

SOLUTION

Helen Feddema

5/14/2013

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options