Solved

Microsoft Access 2010 subform formatting with datasheet view

Posted on 2013-05-14
6
3,567 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 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Familiarize people with the process of utilizing SQL Server functions 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 Ac…
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…

679 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