Solved

Microsoft Access 2010 subform formatting with datasheet view

Posted on 2013-05-14
6
3,588 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 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 50

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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

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…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

738 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