• Changing Field Names Throughout Database (97/2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Changing Field Names Throughout Database (97/2000)

    Author
    Topic
    #364027

    Because I learned Access on my own while building a database, I now find that I have a few inappropriate field names (for example “E-mail” instead of “EMail” which forces me to use brackets in code because of the hyphen). By now, of course, that field name is embedded in numerous queries, forms, reports, and code modules.

    My question is, is there any easy way to locate all the incidences of such a field and change them? I don’t mind changing them manually once I find them if necessary – it’s finding them that is the issue so I don’t miss one (or twelve smile ) and have something malfunction when someone else is using the database.

    thanks,
    -cynthia

    Viewing 0 reply threads
    Author
    Replies
    Viewing 0 reply threads
    Reply To: Changing Field Names Throughout Database (97/2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: