M
mcnews
how to change the background color of a cell/field in a continuous
form?
tia,
mcnewsxp
form?
tia,
mcnewsxp
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
mcnews
how to change the background color of a cell/field in a continuous
form?
tia,
mcnewsxp
sorry - i meant change the background color for an entire column on a
datasheet.
F
fredg
sorry - i meant change the background color for an entire column on a
datasheet.
What Access version?
Form Datasheet View?
What datatype field?
If you are using Access 2000 or newer:
In form design view, use conditional formatting on that control.
If it's a number field, for example, set the Condition1 to
Expression Is
Write:
IsNull(FieldName]) or [FieldName] <= -9999
in the next dialog box.
Write -9999 (or as small a value as will work in all instances) in
the next dialog.
Run the form in Datasheet view.
You can do something similar if the field is Text datatype.
Set the Expression Is to:
IsNull([FieldName]) or [FieldName] < "ZZZZ"
M
mcnews
sorry - i meant change the background color for an entire column on a
datasheet.
What Access version?
Form Datasheet View?
What datatype field?
If you are using Access 2000 or newer:
In form design view, use conditional formatting on that control.
If it's a number field, for example, set the Condition1 to
Expression Is
Write:
IsNull(FieldName]) or [FieldName] <= -9999
in the next dialog box.
Write -9999 (or as small a value as will work in all instances) in
the next dialog.
Run the form in Datasheet view.
You can do something similar if the field is Text datatype.
Set the Expression Is to:
IsNull([FieldName]) or [FieldName] < "ZZZZ"
access 2003
where do i find conditional formatting option?
M
mcnews
sorry - i meant change the background color for an entire column on a
datasheet.
What Access version?
Form Datasheet View?
What datatype field?
If you are using Access 2000 or newer:
In form design view, use conditional formatting on that control.
If it's a number field, for example, set the Condition1 to
Expression Is
Write:
IsNull(FieldName]) or [FieldName] <= -9999
in the next dialog box.
Write -9999 (or as small a value as will work in all instances) in
the next dialog.
Run the form in Datasheet view.
You can do something similar if the field is Text datatype.
Set the Expression Is to:
IsNull([FieldName]) or [FieldName] < "ZZZZ"
thanks - i found it!
F
fredg
how to change the background color of a cell/field in a continuous
form?
sorry - i meant change the background color for an entire column on a
datasheet.
What Access version?
Form Datasheet View?
What datatype field?
If you are using Access 2000 or newer:
In form design view, use conditional formatting on that control.
If it's a number field, for example, set the Condition1 to
Expression Is
Write:
IsNull(FieldName]) or [FieldName] <= -9999
in the next dialog box.
Write -9999 (or as small a value as will work in all instances) in
the next dialog.
Run the form in Datasheet view.
You can do something similar if the field is Text datatype.
Set the Expression Is to:
IsNull([FieldName]) or [FieldName] < "ZZZZ"
access 2003
where do i find conditional formatting option?
In Form Design View, select the control to be conditionally formatted.
Then click Format + Conditional Format.
Or ....
Right-click on the control and select Conditional Formatting
M
mcnews
On 26 Feb 2007 10:51:08 -0800, mcnews wrote:
how to change the background color of a cell/field in a continuous
form?
tia,
mcnewsxp
sorry - i meant change the background color for an entire column on a
datasheet.
What Access version?
Form Datasheet View?
What datatype field?
If you are using Access 2000 or newer:
In form design view, use conditional formatting on that control.
If it's a number field, for example, set the Condition1 to
Expression Is
Write:
IsNull(FieldName]) or [FieldName] <= -9999
in the next dialog box.
Write -9999 (or as small a value as will work in all instances) in
the next dialog.
Run the form in Datasheet view.
You can do something similar if the field is Text datatype.
Set the Expression Is to:
IsNull([FieldName]) or [FieldName] < "ZZZZ"access 2003
where do i find conditional formatting option?
In Form Design View, select the control to be conditionally formatted.
Then click Format + Conditional Format.
Or ....
Right-click on the control and select Conditional Formatting
certainly slows things down doesn't it.........!
M
mcnews
On 26 Feb 2007 10:51:08 -0800, mcnews wrote:
how to change the background color of a cell/field in a continuous
form?
tia,
mcnewsxp
sorry - i meant change the background color for an entire column on a
datasheet.
What Access version?
Form Datasheet View?
What datatype field?
If you are using Access 2000 or newer:
In form design view, use conditional formatting on that control.
If it's a number field, for example, set the Condition1 to
Expression Is
Write:
IsNull(FieldName]) or [FieldName] <= -9999
in the next dialog box.
Write -9999 (or as small a value as will work in all instances) in
the next dialog.
Run the form in Datasheet view.
You can do something similar if the field is Text datatype.
Set the Expression Is to:
IsNull([FieldName]) or [FieldName] < "ZZZZ"access 2003
where do i find conditional formatting option?
In Form Design View, select the control to be conditionally formatted.
Then click Format + Conditional Format.
Or ....
Right-click on the control and select Conditional Formatting
is it possible to change the color of a column header?
F
fredg
On 26 Feb 2007 10:51:08 -0800, mcnews wrote:how to change the background color of a cell/field in a continuous
form?
sorry - i meant change the background color for an entire column on a
datasheet.What Access version?
Form Datasheet View?
What datatype field?If you are using Access 2000 or newer:
In form design view, use conditional formatting on that control.If it's a number field, for example, set the Condition1 to
Expression Is
Write:
IsNull(FieldName]) or [FieldName] <= -9999in the next dialog box.
Write -9999 (or as small a value as will work in all instances) in
the next dialog.Run the form in Datasheet view.You can do something similar if the field is Text datatype.
Set the Expression Is to:IsNull([FieldName]) or [FieldName] < "ZZZZ"access 2003
where do i find conditional formatting option?
In Form Design View, select the control to be conditionally formatted.
Then click Format + Conditional Format.
Or ....
Right-click on the control and select Conditional Formatting
is it possible to change the color of a column header?
Not in datasheet view.
In form continuous view you have much more control and you can make it
look very similar to a datasheet with a bit of work. In which case you
won't need conditional formatting. Just set the control's back color.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.