check null on "Continuous Forms", change backcolour

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

OTWarrior - 24 Jul 2007 09:09 GMT

I have a form using a query that displays the count of the different types of
data inputted that month (so the form would normally look like this:)

type1 36
type2 23
type4 89

or

type1 78
type2 54
type3 23
type4 40

if there has been no work done for that type that month, the type will not
show (as it is a null value)

is there a way of checking for that null? I want to make the form a different
colour if there hasn't been any work done in that area.

Since there are no records that appear, is there a property for that (ie: row
count?)

Reply to this Message

Marshall Barton - 24 Jul 2007 17:14 GMT

>I have a form using a query that displays the count of the different types of
>data inputted that month (so the form would normally look like this:)
[quoted text clipped - 18 lines]
>Since there are no records that appear, is there a property for that (ie: row
>count?)

The records with Null are not appearing because they are
not in the form's record source query. Forget the form for
now and work on the query.

I can't ne sure without seeing it, but I suspect that all
you need to so is change the query to use an outer join
insteaf of inner join.

Signature

Marsh
MVP [MS Access]

Reply to this Message