Can all fields and contents be viewed in 1 window?

[charlie6067]

I'm familiar with Shift + F2 to view the data of 1 field in a separate
window -- very useful for editing long text fields. In Paradox, there
was a keystroke or menu item that displayed all fields and contents in
a separate window, although scrolling down was required to see all of
the fields. Is there a similar feature in Access 97?

Thanks,
charlie6067

[charlie6067]

I meant to say, "In Paradox, there was a keystroke or menu item that
displayed all fields and contents of a selected row in a separate
window."

Charlie
charlie6067

[Larry Linson]

"charlie6067" <ch*********@yahoo.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

I meant to say, "In Paradox, there was a keystroke or menu item that
displayed all fields and contents of a selected row in a separate
window."

No, but often we display a list of summary data in continuous forms view,
and use a double-click or a button on the record with VBA code
DoCmd.OpenForm to open a form that shows all fields of the current record.

Larry Linson
Microsoft Access MVP

[David W. Fenton]

"Larry Linson" <bo*****@localhost.not> wrote in
news:CDZ9e.80744$B12.7386@trnddc09:

"charlie6067" <ch*********@yahoo.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

I meant to say, "In Paradox, there was a keystroke or menu item
that displayed all fields and contents of a selected row in a
separate window."

No, but often we display a list of summary data in continuous
forms view, and use a double-click or a button on the record with
VBA code DoCmd.OpenForm to open a form that shows all fields of
the current record.

In Paradox, as I'm sure you remember, Larry, there was a handy
autoform feature, that created a
not-very-attractive-but-barely-usable form. In Access, you'd run the
form wizard to accomplish the same thing. The advantage of the PDOX
approach was that it always started from scratch so that if you
added any new fields, the next time you did the autoform thing, it
would pick up all the new fields. With Access you'd have to rerun
the form wizard and save over the original (assuming you saved it).

But in neither case is the result terribly useful or attractive. I
only use that kind of thing for quick-and-dirty dbs were I'm going
to be the only one using it.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc