Refresh (?) label

[an]

Hello!

In one Form, I have two Labels (red and green), next the
text box for SUM.
The labels "change" color consonant positive or negative
value of SUM.
When we change de value in indiviuals text box, the value
of SUM change naturally. But the label don't move.
How is possible refresh (ou requery) the labels, after
change values in text boxes, please.

Thanks in advance.
an

 

[John Vinson]

Hello!

In one Form, I have two Labels (red and green), next the
text box for SUM.
The labels "change" color consonant positive or negative
value of SUM.
When we change de value in indiviuals text box, the value
of SUM change naturally. But the label don't move.
How is possible refresh (ou requery) the labels, after
change values in text boxes, please.

Thanks in advance.
an

If you have Access2002 or later, you can use "Conditional Formatting"
- select the label, and select Format... Conditional Formatting from
the menu.

For older versions, you can put a line

Me.Repaint

in the VBA code for the AfterUpdate event of whatever control changes
the Sum, and also the Form's Current evetn.

John W. Vinson[MVP]

 

[an]

Ok.

Many thanks for your help.
an

-----Original Message-----


If you have Access2002 or later, you can use "Conditional Formatting"
- select the label, and select Format... Conditional Formatting from
the menu.

For older versions, you can put a line

Me.Repaint

in the VBA code for the AfterUpdate event of whatever control changes
the Sum, and also the Form's Current evetn.

John W. Vinson[MVP]
.

 

[an]

Ooops!

I have Access 2000.
After write de code and when I try to change data in text
box, return the next message menu:

Microsoft Access can't find the macro '.'
The macro (or its macro group) doesn't exist, ...

When I haven't any macro... (?)
Why this message, please?

Many Tanks
an

 

[John Vinson]

Ooops!

I have Access 2000.
After write de code and when I try to change data in text
box, return the next message menu:

Microsoft Access can't find the macro '.'
The macro (or its macro group) doesn't exist, ...

When I haven't any macro... (?)
Why this message, please?

Take a look at the Events tab in the Properties whichever form or
control you were editing. There is probably a period "." in one of the
Events; these fields should be either:

- blank
- the name of a Macro
- =SomeValidFunctionName()
- [Event Procedure]

My guess is that you unintentionally put a period into one of them in
the course of editing.

John W. Vinson[MVP]

 

[an]

Ohhh Ok, Mr JV.
Sorry.
Thank you for your help.
Work fine.

Grateful.
an

-----Original Message-----

Ooops!

I have Access 2000.
After write de code and when I try to change data in text
box, return the next message menu:

Microsoft Access can't find the macro '.'
The macro (or its macro group) doesn't exist, ...

When I haven't any macro... (?)
Why this message, please?

Take a look at the Events tab in the Properties whichever form or
control you were editing. There is probably a period "." in one of the
Events; these fields should be either:

- blank
- the name of a Macro
- =SomeValidFunctionName()
- [Event Procedure]

My guess is that you unintentionally put a period into one of them in
the course of editing.

John W. Vinson[MVP]
.