Need Syntax in Make Table Query to Create an Empty Text Field, Not Binary

Question

I have a Make-Table query that creates an empty field of data in my table with the following line in the 'Field' row:

ACES_Year: Null

When I run this and it creates a table, of course, it creates a blank field with the data type of 'Binary'. I have to go to design mode for that table and manually change the field to 'Text'. I have seen before a way to create a blank field that is automatically designated as type within the Make-table query, but I am pulling my hair our trying to find it again.

I am sure someone knows how to do it - please help!

Jen

Answer 1

Did you try:

ACES_Year: ""

Answer 2

A good place to start is probably Crystal's Learn VBA tutorial at http://www.accessmvp.com/Strive4Peace/VBA.htm

Answer 3

Thank you so much for your answer. Unfortunately I am not VB saavy and so I don't really know how to implement the suggestion above. Are you willing to let me know in more detail what you mean?

This is an out-of-range request, because I know this isn't meant to be a training forum, so if it's complicated, I will completely understand. Perhaps you can direct me to somewhere that would help be understand very basic VB usage for MS Office products?

Answer 4

Hooray!!! That's just what I was looking for. Thank you.

Answer 5

Why not add the field to the table after you've run the Make table query? It only takes a couple of lines of VBA:

Dim tdf As DAO.TableDef

  Set tdf = CurrentDb.TableDefs("NameOfTable")

  With tdf

    .Fields.Append .CreateField("ACES_Year", dbText)

  End With

  Set tdf = Nothing