Re: Visible records

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Man-wai Chang,

Is there a way to tell whether a certain record is being displayed in a grid?
If order is set to 0 and no filter is set (not even DELETED) and the active row is in the visible part, you could do some calculations with .height, .rowheight, ..headerheight, .activerow, .relativerow and others to find it. But if a filter is set or an order, then I don't see a reasonable way.
The grid does not disclose such secrets.

I meant not just the recno(grid.recordsource) because it's always in sight.
If you scrolled vertically with the mouse, the active row can get out of the visible part of the grid!

Regards
Bernhard Sander
.

Relevant Pages

  • Re: control over grid scrolling
    ... > Anyone know a good way to scroll a grid, ... to put the active row in a certain position in the visible area? ... > Say for instance, with a grid that has 10 rows showing, to make the active ... > Setting relativerow would work great, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Visible records
    ... active row is in the visible part, you could do some calculations with ... But if a filter is set or an order, ... The grid does not disclose such secrets. ...
    (microsoft.public.fox.programmer.exchange)
  • control over grid scrolling
    ... Anyone know a good way to scroll a grid, without moving the record pointer, ... to put the active row in a certain position in the visible area? ...
    (microsoft.public.fox.programmer.exchange)
  • Re: control over grid scrolling
    ... activerow and activecolumn are zero if the grid doesn't have focus. ... > RelativeRow is 0, when the active row is outside the visible area. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Display if count = 5
    ... criteria line of the field that is being counted, ... And, if you count something in the design grid in a query, ... if you have designed a complicated filter. ...
    (microsoft.public.access.queries)