Homescreen form design

DamitScubaSteve

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

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:

Mar 21 '17 #2

DamitScubaSteve

Ah. Cool. I'll look into that.

Mar 21 '17 #3