471,887 Members | 1,083 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,887 software developers and data experts.

Homescreen form design

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:


2 780
jforbes
1,107 Expert 1GB
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, 123 views)
Mar 21 '17 #2
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.

Similar topics

1 post views Thread by WJ | last post: by
4 posts views Thread by yanjie.ma | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.