By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,135 Members | 1,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,135 IT Pros & Developers. It's quick & easy.

Homescreen form design

P: 5
Just wanting some input on the best way to go about designing my homescreen form.

This database is mainly for case management. Right now I have it so that all my navigation buttons are on the left with multiple list boxes in the body of the form. Each list box represents different deadlines for when certain paperwork needs to be sent out/follow up on specific things/hearing dates.

I like that I can set the listboxes up to doubleclick on a specific record and go to their corresponding form and how clean they look, but I also want to be able to have specific things be highlighted to bring more attention to them. For instance, if we have a hearing coming up, I want that to be highlighed in RED. I would also like more control over the highlight color in general.

Any thoughts? Is there a way I can have all the things or will I have to pick and choose? I've also made up the same form, but with datasheet subforms just to get a sense for how they looked, but they're more bulky than the list boxes. If there are other options, I'm open to trying to them out as well.
Mar 20 '17 #1

✓ answered by jforbes

You might want to check out this Question: Set Colour for Current Record

ListBoxes are very clean, but the ListBox that ships with Access doesn't support what your are after. You could attempt to get a third part control that might do what your after, but that is a pretty huge undertaking and there is a cost associated with purchasing the control.

What I would recommend is checking out the link, it shows how colors of the background can be changed per record.

This is an example of how I use that technique:


Share this Question
Share on Google+
2 Replies


jforbes
Expert 100+
P: 1,107
You might want to check out this Question: Set Colour for Current Record

ListBoxes are very clean, but the ListBox that ships with Access doesn't support what your are after. You could attempt to get a third part control that might do what your after, but that is a pretty huge undertaking and there is a cost associated with purchasing the control.

What I would recommend is checking out the link, it shows how colors of the background can be changed per record.

This is an example of how I use that technique:

Attached Images
File Type: jpg DashboardScreenshot.jpg (78.6 KB, 60 views)
Mar 21 '17 #2

P: 5
Ah. Cool. I'll look into that.
Mar 21 '17 #3

Post your reply

Sign in to post your reply or Sign up for a free account.