delete space in field names

[holgi123]

Hi Everyone,

is there a way to a) programatically delete [blank] within field names for tables, i.e. convert tbl1.[Field Name 1] to tbl1.[FieldName1]. I might have to do this for several tables and heap of fields. Secondly is there a way to programatically change my forms and queries. I tried this auto-correct but it does not seem to work.

Any help would be much appeciated.

 

[abaldwin]

Have a look at adox for the creation and renaming of tables. As for the forms......mmmmmmmmmm have not done that before. I do very little form and query work in Access. Usually only store data in it.



Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.