 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / April 2005Show calculated fields while scrolling
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 > Hi > I have a text box on a continuous form which displays a [quoted text clipped - 12 lines] > TIA > Kevin R 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 [quoted text clipped - 26 lines] >> TIA >> Kevin R |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.