Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Microsoft Access 2010 subform formatting with datasheet view

Posted on 2013-05-14
6
Medium Priority
?
3,696 Views
Last Modified: 2013-05-18
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!
0
Comment
Question by:pabrann
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 14

Accepted Solution

by:
Bill Ross earned 1000 total points
ID: 39165021
Hi,

Suggest you use continuous forms and conditional formatting.  Use a query as the recordsource for the subform with the desired expression and use conditional formatting to change the color.

Here is a good MS article on the process:

http://office.microsoft.com/en-us/access-help/change-the-appearance-of-a-control-by-using-conditional-formatting-HA010208133.aspx

Regards,

Bill
0
 

Author Comment

by:pabrann
ID: 39165043
Hi Bill, thanks. Will this work on a subform?
0
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 39165165
>  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
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 14

Expert Comment

by:Bill Ross
ID: 39165222
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
0
 
LVL 31

Assisted Solution

by:Helen Feddema
Helen Feddema earned 1000 total points
ID: 39166061
See my Access Archon article on this topic:

http://www.helenfeddema.com/Files/accarch173.zip

and here is a screen shot:

Current Row back color
0
 

Author Closing Comment

by:pabrann
ID: 39177308
Thank you very much. I was able to accomplish exactly what I desired with comments from Bill and Helen. Excellent!!
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question