How can I get cell data to pop up in a larger window in access ra.

[Guest]

How can I get cell data to pop up in a larger window in access rather than
use vertical scroll bars. I know that some help files have a small button
with a 3 dot ellipsis which is clicked for a more in depth explanation. I
want that cell's data to pop up in a larger separate window. Can this be done?

 

[Guest]

Hi, Zotch.

Not sure what you mean by "cell", as that is an Excel entity. I will guess,
however, that you're looking at data in a continuous form, and that you'd
like to open another form that shows more complete information about this
record by pressing a button.
If this assumption is correct, place a command button on the continuous
form, and either use the wizard or modify the following code for the OnClick
event:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "YourSecondForm"

stLinkCriteria = "[YourPrimaryKey]=" & Me![ControlOnSubformWithPrimaryKey]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Hope that helps.
Sprinks

 

[Ulcom]

Hi

To see the data of a field in a lager window than the cell itself what I do
is

On the doubleclick even of the field just add the following code

docmd.RunCommand acCmdZoomBox

So if you double click the field (or cell like you named it), another window
will open containing field content that you can edit