Prev: Teste
Next: Hide System Fileds in table
From: jubiiab via AccessMonster.com on 19 Mar 2010 10:41
Hi Linq,

when i write this:
[UseSupplier] = -1

I get this message:
The expression you entered contains invalid syntax

Linq Adams wrote:
>Sorry, meant to give you a step-by-step:
>
>Goto Format - Conditional Formatting
>
>Under Condition select "Expression Is"
>
>Then in the next box enter
>
>[UseSupplier] = -1
>
>Now simply use the icons to set the Forecolor you want and Bold it.
>
>Now click on OK
>
>You should be set.
>
>BTW, the only kind of formatting you can do on these types of forms, using
>code in the Form_Current event, is to Lock/Unlock and Enable/Disable controls.
>

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201003/1

From: jubiiab via AccessMonster.com on 19 Mar 2010 10:43
I closed access and did it again - now it works??? Thank you very much for ur
time and help. ;)
jubiiab wrote:
>Hi Linq,
>
>when i write this:
>[UseSupplier] = -1
>
>I get this message:
>The expression you entered contains invalid syntax
>
>>Sorry, meant to give you a step-by-step:
>>
>[quoted text clipped - 14 lines]
>>BTW, the only kind of formatting you can do on these types of forms, using
>>code in the Form_Current event, is to Lock/Unlock and Enable/Disable controls.

--
Message posted via http://www.accessmonster.com

From: Linq Adams via AccessMonster.com on 19 Mar 2010 10:54
Glad we could help!

As to your previous post, I've also run into problems, from time to time,
where valid code in Conditional Formatting didn't work until you closed the
form and then reopened it.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201003/1

From: David W. Fenton on 19 Mar 2010 18:40
"Linq Adams via AccessMonster.com" <u28780(a)uwe> wrote in
news:a53e9b32363b6(a)uwe:

> If the subform is in Datasheet or Continuous View, as most are,
> you cannot do this kind of formatting thru code in the
> Form_Current event. You'll have to use the Conditional Formatting
> from the Format Menu.

In a datasheet, you can change the color of all the cells at once in
code, but not one cell at a time, unless you use conditional
formatting (which has the drawback of painting very slowly in many
cases).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
First  |  Prev  | 
Pages: 1 2
Prev: Teste
Next: Hide System Fileds in table