Re: Text on a form is visinle
- From: Andrew <Andrew@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 4 Oct 2007 23:38:01 -0700
Hi Allen,
Thanks for the reply.
I quickly tried repaint with no luck. I don't think there's anything wrong
with the updating of ON_HAND etc because if I have a modal box open (from any
application) and I gently drag just a little over the text box (even half)
then only that half of the text (eg top half). Will be shown.
I am happy to email (4.3MB unzipped but can zip) to you as I think it's
pretty amazing.
--
Andrew
"Allen Browne" wrote:
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: Allen Browne
- Re: Text on a form is visinle
- References:
- Re: Text on a form is visinle
- From: Allen Browne
- Re: Text on a form is visinle
- Prev by Date: Re: Text on a form is visinle
- Next by Date: Re: Text on a form is visinle
- Previous by thread: Re: Text on a form is visinle
- Next by thread: Re: Text on a form is visinle
- Index(es):
Relevant Pages
|