Phil
asked on
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!
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
> 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
That's because it is ignored in datasheetview.
You have to use conditional formatting in this case.
/gustav
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
Yes. You can design the subform separately and the changes will be available in the main form when the subform is viewed.
Regards,
Bill
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much. I was able to accomplish exactly what I desired with comments from Bill and Helen. Excellent!!
ASKER