Show calculated fields while scrolling

  • Thread starter Thread starter Kevin R
  • Start date Start date
K

Kevin R

Hi
I have a text box on a continuous form which displays a
concatenation of string values from three separate fields.
(i.e. Title, initials and surname)

If I scroll up or down, using the scroll bar, then the calculated
fields which have now scrolled in to view remain blank until I
release the scroll bar. They work fine if I use the scroll wheel

Any way to get them to update while scrolling ?

It's not a major concern, but I just know I'm going to be asked
about this.

TIA
Kevin R
 
Kevin,
I'm not sure, bu I think if you add those concatenated fields to your
query that may not happen.
If... on your subform, you have a field with = [LastName] & ", " &
[FirstName] try adding a field to the form query like this...
FullName : [LastName] & ", " & [FirstName]
and set the subform field to...
= [FullName]
Now... that field is "bound", and may display (while scrolling) without
blinking.
(didn't have a chance to test, but worth a try...)
hth
Al Camp
 
Works like a charm
thanks very much

Kevin R.


Kevin,
I'm not sure, bu I think if you add those concatenated fields to your
query that may not happen.
If... on your subform, you have a field with = [LastName] & ", " &
[FirstName] try adding a field to the form query like this...
FullName : [LastName] & ", " & [FirstName]
and set the subform field to...
= [FullName]
Now... that field is "bound", and may display (while scrolling) without
blinking.
(didn't have a chance to test, but worth a try...)
hth
Al Camp

Kevin R said:
Hi
I have a text box on a continuous form which displays a
concatenation of string values from three separate fields.
(i.e. Title, initials and surname)

If I scroll up or down, using the scroll bar, then the calculated
fields which have now scrolled in to view remain blank until I
release the scroll bar. They work fine if I use the scroll wheel

Any way to get them to update while scrolling ?

It's not a major concern, but I just know I'm going to be asked
about this.

TIA
Kevin R
Click to expand...
Click to expand...
 
Back
Top