Popup Form in larger font

[BennyLinton]

I need to have the ability to have the user click on a notes field/textbox and have that launch another form that has the information in a quite larger font and it be sync'd to the Notes Textbox I have so they can see it better and have their edits immediately seen on the main screen... is this possible?

 

[theDBguy]

Of course. For example, you could create a smaller form bound to the same table as your form now and only include the Notes field on it. Make the font size as big as you'd like and when you're ready to open it, you could try something like:

DoCmd.OpenForm "FormName", , , "ID=" & Me.ID

You'll probably need more code than that, but give it a shot for now.

 

[BennyLinton]

That works so far.. .I just need to write some code to refresh the main form... thanks

 

[MajP]

have their edits immediately seen on the main screen...

Adding to what DBGuy said. You probably want to open the pop up as Acdialog. This will stop code execution in the calling form. When the pop up closes it will return code execution to the calling form. Then you will need to requery to see your changes

Something like

dim tempID as long
tempID = me.ID
DoCmd.OpenForm "FormName", , , "ID=" & Me.ID,,ACDIALOG
'code stopped until called form closes
me.requery 'refresh the changes
me.recordset.findfirst "ID = " & TempID

 

[BennyLinton]

Last bit of code works perfectly... thanks!!

 

[theDBguy]

Last bit of code works perfectly... thanks!!

Congratulations! Glad to hear you got it working. Good luck with your project.


MajP, thanks for the assist!

 

[MajP]

FYI. I would likely do this customized approach; however, Access does have a zoombox built in. You could call this from any textbox on a double click event for example.

Public Function openZoomBox()
  DoCmd.RunCommand acCmdZoomBox
End Function