Unlocked Zoombox Wizard for Access 2002

[Dan]

Does anyone know how to obtain the unlocked Access code
for running the
command "DoCmd.RunCommand acCmdZoomBox" (also invoked by
shift-F2)? I've
got a custom zoombox (inspired in part by looking at the
unlocked Access
2.0 Wizards, and also by William Hindman's popups.zip).
Its purpose is to
allow a user to enter a new line of data without having
to press ctrl-
enter, but simply press <enter>.

It works fine when the back end tables are in Jet, but
when they're in SQL
Server, I've found that setting the text property of a
control bound to a
SQL Server 2000 field causes an error 2176 when the text
length is greater
than 2000 chars. Setting the value property gives no
error, but drops all
but the last 163 characters.

What's interesting is that I can use ctrl-V to paste text
larger than 2000
chars into the field, but it seems a bit unwieldy to use
the Windows APIs
to paste data.

I'm starting to guess that maybe the Access 2002 zoom box
isn't written in
Access, but uses some sort of API. Any ideas?

Thanks,
- Dan

P.S. - If you'd like to email me directly, just delete
the text "deletethis" from the email address above.