Field condition on reports module

[kft10 via AccessMonster.com]

Hi,

I have 1 simple question, but I don't know how to write VB script in Access.
On reports module, I'd like to print red font on field1 if that field1
greater than 50. Does anyone can help to write in VB script?

Thank you in advance.

KF

 

[Duane Hookom]

You don't need to write any code. Use Conditional Formatting.

 

[kft10 via AccessMonster.com]

I did try to put the condition on Field1 textbox in Fore Color property like
this:

=iif(field1>.5,233,0)

But it didn't work. Do you have any ideas, where I have to put the
conditional format on? Thank you.

KF

 

[Duane Hookom]

Apparently you didn't find the Conditional Formatting in the Format menu in
design view. What version of Access are you using?

 

[kft10 via AccessMonster.com]

I am suing Access 2003.

Apparently you didn't find the Conditional Formatting in the Format menu in
design view. What version of Access are you using?

I did try to put the condition on Field1 textbox in Fore Color property like
this:

[quoted text clipped - 15 lines]

 

[Duane Hookom]

So am I.
What exactly did you enter where? Did you find Conditional Formatting?

--
Duane Hookom
Microsoft Access MVP

I am suing Access 2003.

Apparently you didn't find the Conditional Formatting in the Format menu in
design view. What version of Access are you using?

I did try to put the condition on Field1 textbox in Fore Color property like
this:

[quoted text clipped - 15 lines]

KF

 

[kft10 via AccessMonster.com]

Sorry, It is typo. I meant I am using Access 2003.

So am I.
What exactly did you enter where? Did you find Conditional Formatting?

I am suing Access 2003.

[quoted text clipped - 6 lines]

 

[kft10 via AccessMonster.com]

It works now. Thank you so much.

Hi,

I have 1 simple question, but I don't know how to write VB script in Access.
On reports module, I'd like to print red font on field1 if that field1
greater than 50. Does anyone can help to write in VB script?

Thank you in advance.

KF

 

[Duane Hookom]

I knew that.
--
Duane Hookom
Microsoft Access MVP

Sorry, It is typo. I meant I am using Access 2003.

So am I.
What exactly did you enter where? Did you find Conditional Formatting?

I am suing Access 2003.

[quoted text clipped - 6 lines]

KF