You might wish to consider this alternative, but it means
changing your user interface to a continuous form from a
datasheet and it will look quite different.
1/ Create a new continuous form based on your table or query
(with bound controls - using the wizard and modifying the
result in design view might be quickest).
2/ In this new form, in design view, copy and paste the data
controls from the detail section into the footer section.
3/ Change the formatting of the controls in the footer to
look different from the detail ones in terms of colour,
bolding, font size or whatever you like.
Now when you run the form, whichever record (row) is current
in the detail section will be repeated in the
loud/bold/bright footer.
Another option is to only have a few of your fields in the
detail section to speed row browsing and all of them in the
footer.
Further info:- Note that although there are ways in code to
get at the currently selected (needs selectors enabled)
record or records in a datasheet or continuous form
(SelHeight, SelLeft etc etc) you can't go back and format
just that row. I suppose you could set an extra control
(formatted to red perhaps) on the current record with a
character like ! or something but you're into a fair bit of
code to achieve that and I don't think it would be visually
obvious to the user.
--
Nick Coe (UK)
http://www.alphacos.co.uk/
In
ChangHoon EIm typed:
