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
Solved

Microsoft Access 2010 subform formatting with datasheet view

Posted on 2013-05-14
6
3,536 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
6 Comments
 
LVL 14

Accepted Solution

by:
Bill Ross earned 250 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 49

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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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 250 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

856 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