Text on a form is visinle

A

Andrew

Hi,

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.
 
A

Allen Browne

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
 
A

Andrew

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 said:
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

Reply to group, rather than allenbrowne at mvps dot org.

Andrew said:
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.
Click to expand...
Click to expand...
 
A

Allen Browne

Andrew, I'm not sure that Access failing to display a value properly counts
as "amazing." :)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Andrew said:
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 said:
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

Andrew said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Top