Ability to view the Field list in the VBA Code Module
When you are in the VBA Code Editor, and you want to refer to a field on the form, you have to flip back to the form to find the field name before you can use it.
It would life so much easier if the field names were listable in the code module in the View option as per the Object Command on the Form's Design View.
Nigel Vandyk
shared this idea
3 comments
-
James Lee
commented
Comment on an idea about VBA IDE that's under review at https://officespdev.uservoice.com/forums/224641-feature-requests-and-feedback/suggestions/15446658-give-the-vba-ide-a-major-overhaul-finally
-
Nigel Vandyk
commented
Yes indeed to be able to do that would be great, but more important than that to see a list of all the field names for a form or report when writing code so you don't need to flip between the field design view and the form code module.
I think this would be relatively easy to do, would not affect earlier versions of Access and make coding easier and much less liable to mistakes. Please give this suggestion your support!
-
Matty Brown commented
Do you mean when you type Me!, you'd like it to list the field names that are bound to the form/report so you don't have to guess them or look them up?