OK, this can be deleted for now. I was running this and nothing was updating. I went into design mode to verify they were all setup as text fields, and when I returned to the datasheet view they were there. I had to update the table, I didn't realize this.

This question could probably be deleted now, but if anyone can think of a better way to do what I'm doing, I'd love to hear it..