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

Coloring a field on a Continuous form base data in Field

P: n/a
I have a Continuous form in Access 2000. The form contains a date field
and the user has requested( demanded nicely) that they want the date
field to be yellow if there is no data in the field. Does anyone know
how to do this?

Nov 16 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
In the forms current properties try the following:

If IsNull(Me.somedate) Then
Me.somedate.BackColor = vbYellow
End If

"James" <jn*******@gmail.comwrote in message
news:11*********************@e3g2000cwe.googlegrou ps.com...
>I have a Continuous form in Access 2000. The form contains a date field
and the user has requested( demanded nicely) that they want the date
field to be yellow if there is no data in the field. Does anyone know
how to do this?

Nov 16 '06 #2

P: n/a
SBC News Groups wrote:
If IsNull(Me.somedate) Then
Me.somedate.BackColor = vbYellow
End If
This won't work.

James, take a look at conditional formatting. It will do what your
client wants.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me
Nov 16 '06 #3

P: n/a
OR

Conditional formating for that field

1 way --- set the conditional formating test to "Expression"
and make the expression isnull([somedatefieldname])=true

and select the color formating that you want.

Nov 16 '06 #4

P: n/a
On 16 Nov 2006 11:36:39 -0800, James wrote:
I have a Continuous form in Access 2000. The form contains a date field
and the user has requested( demanded nicely) that they want the date
field to be yellow if there is no data in the field. Does anyone know
how to do this?
On a continuous form, using Access 2000, use the control's Conditional
Formatting property.
Select that date control.
Click Format+ Conditional Formatting

Set the Condition1 drop-down to
Field Value is
Write:
IsNull([DateControlName])
in the next box.
Select the color you want.
Click OK.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Nov 16 '06 #5

P: n/a
On Thu, 16 Nov 2006 19:45:19 GMT, "SBC News Groups" <me@you.netwrote:
>In the forms current properties try the following:

If IsNull(Me.somedate) Then
Me.somedate.BackColor = vbYellow
End If
This will set the back colour of the control for every record in the subform,
not just the current record.

As others have suggested Conditional Formatting is the answer.

Wayne Gillespie
Gosford NSW Australia
Nov 17 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.