Re: Text on a form is visinle
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Fri, 5 Oct 2007 13:05:24 +0800
Could be one of several things.
First thing to chekc is the name of the *control* bound to the [Buying Office Comments] field. If the field has that name, but the text box is called something else (such as Text74), the text box won't get the updated value until the record is saved. To avoid that, use:
Me.Text74 = "SOH...
Access has always had a display problem in the header or footer section of a form that has no records to display when no new records can be added. Details in:
Incorrect display of data
at:
http://allenbrowne.com/bug-06.html
There can also be timing/display issues if ON_HAND or ON_ORDER are combo boxes where the bound column is zero-width.
Finally, there could be a problem with the video driver, such that turning off hardware acceleration would solve it. (This seems unlikely, unless the other computer you tried it on has the same driver issue.)
Since you are doing this in an event, you may be able to work around it with by forcing a screen redraw:
Me.Repaint
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Andrew" <Andrew@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7212D049-331F-45C8-9015-C001729294CA@xxxxxxxxxxxxxxxx
I have a form with a text box and a button on it. When the user clicks on
the button text is MEANT TO BE entered into the text box. I use the
statement:
[Buying Office Comments].Value = "SOH: = " & [ON_HAND] & ", SOO: = " &
[ON_ORDER]
However, when I clicked on the button nothing happened. If I closed the
form and re-opened it the text was there. Then if I clicked and 'alt-tabbed'
to the VBA box and back it appeared!
Then I found if I clicked on the button and dragged a dialogue box (of any
type) ofver the text it magically appeared!!!!
Now, this may be good if this is the result I was looking for but alas it is
not.
I tried this on another PC with the same result. We are using Access 2000
and XP.
Can anyone please assist.
--
Andrew Buchter
.
- Follow-Ups:
- Re: Text on a form is visinle
- From: Andrew
- Re: Text on a form is visinle
- Prev by Date: form tab duplicate
- Next by Date: Re: Text on a form is visinle
- Previous by thread: form tab duplicate
- Next by thread: Re: Text on a form is visinle
- Index(es):
Relevant Pages
|
