Dynamic Label Caption
Sounds like you have something (possibly just a space " ") in the sell to the
right of the label. If so, delete it and the full caption should show.
HTH,
Gary Brown
"Turtle MacDermott" wrote:
I have a spreadsheet which I am filling from Access using VBA.
I put a label on it, using the Controls Toolbox.
The label's caption reads "Created:"
In VBA, I set
ActiveSheet.OLEObjects("MyLabel").object.caption=" Created: " & Now()
When I step through the code, I see the caption being set correctly.
Now, when I look at the spreadsheet, I see the original caption, "Created:"
without the date.
But if I click on the label, it shows the entire value.
Click off it to something else, and it returns to the original value.
How can I make it display the new value even when the label is not selected?
TIA
- Turtle
|