ALTER TABLE space in field name

[LB79]

Hello,

I'm trying to amend a table column property, but I'm having trouble with a space.

I'm using:
DoCmd.RunSQL "ALTER TABLE Table ALTER COLUMN My Field Text;"

The space in My Field is causing a debug. I've tried ‘My Field’ and My Field, (with the comma), but im not getting it right.

Thanks for any advice.

 

[JANR]

DoCmd.RunSQL "ALTER TABLE Table ALTER COLUMN [My Field] Text;"

Use Brackets [ ] around fieldnames with spaces

JR

 

[LB79]

Oh of course! How did i not realise that!

Thanks for pointing that out

 

[ghudson]

Another reason to avoid spaces and special characters when naming your db objects.