colour coded results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone,

Ive been asked to make a form which searches for results and displays the
records in the same form with colour coding to show various inclinations for
the records.

In this case its looking for empty rooms in a builidng and finding out
whether the other occupants of that flat are all female or smokers etc, which
would be relevent information for when you want to allocate that room to a
new tenant.

At the moment, the query works fine and when you click on a resultant record
it brings up the corresponding records information in another list box next
to it so that you can view all the data, what it doesnt do is colour code it
so the user can see which rooms are what at a glance, which i cant seem to
find how to do with list boxes, i am thinking that i might be able to do it
with subforms but am looking for guidance and suggestions on how i should be
doing this.

thanks in advance for taking the time to read my question and also for any
suggestions you might have,

Amit
 
If you are looking to show different records in a continuous form in
different colors, the only way I'm aware of is to use Conditional Formatting
(Format, Conditional Formatting in Form Design View). Enter one or more
conditions or criteria, and specify the formatting to be associated with them.

Another approach is to have multiple subforms on your main form, with the
RecordSource of each being a query that selects only a subset of the records.
Then you could apply different formatting to each subform, or combine it
with Conditional Formatting.

Hope that helps.
Sprinks
 
Thanks Sprinks,

yeah i was thinking of using a continous form with conditional formatting,
just seemed clumsy but would work if you were looking at flats of less than 9
rooms (ie 9 records).

By having multiple subforms, do you mean having a subform that displays only
'single sex rooms', 'smoking rooms' etc. I didnt understand this properly (my
team, Liverpool won last night and we were out partying till quite late, the
streets were filled with happy people so we had to join in!).

with thanks,

Amit
 
Re: last nights partying--it was a moral imperative.

Yes, that's what I meant--what you're trying to do with color is to
distinguish between various types of rooms. Another way would be to group
them in separate subforms.

Hope that helps.
Sprinks
 
Back
Top