Auto-complete should work if your field is text and you aren't using a hidden column 1.
I never figured out why that option was grayed out, but it was. The first column was not hidden. However I was able to change the design of the field to get what I needed.
Thanks for the help Phil.