For anyone who would like to edit fields full-screen, the following macro might be useful.
It uses the Extra Text field as a temporary field for editing.
To be able to use it, the database must have the Extra Text field activated, and it should not be used for anything else.
I've chosen to have the Extra Text NOT visible when the database is opened, so users will not even see (or know) that it exists. I've assigned F6 to the macro. It should only work when the user is editing.
What the macro does, is very simple.
If the user is in the main format, the macro remembers the active field.
It puts the content of the active field into the Extra Text and then it makes the Extra Text visible. The user has a whole screen to edit the text. You can even use TAB's.
When the user presses F6 again, the second part of the macro is executed. The cursor returns to the previously active field in the main format, and the edited text is copied to that field.
The Extra Text is emptied.
Here's the macro:
if ExtraText = 0 then
scrap(1) = ActiveFieldname
Fields("**") = ActiveField
ExtraText = 1
ActiveField = Fields("**")
Fields("**") = ""