VB to set Field Datatype

[Dave Schoenbrun]

I've got a Make Table query that will run when a user clicks a form button.
The table being created has 4 fields: 3 fields from existing tables and one
"blank" field that I created in the query by giving the name the field:
Amount: ""
This creates a blank field that becomes an editable field when referenced.

I'd like to use my code to set the Data Type of this field in the newly
created table to Currency. I'm having a heck of a time figuring out how to
reference this field.

any suggestions?

 

[Alex Dybenko]

Hi,
try to define this field as:
Amount: ccur(0)

and then you can update it to Null if necessary

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Dave Schoenbrun]

That did the trick, Alex. Thanks.

Hi,
try to define this field as:
Amount: ccur(0)

and then you can update it to Null if necessary

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[John Spencer]

Anoter way that might work and populate the field with null, but define the
field as Currency is to use the following expression in the make table
query.

Amount: IIF(True, Null, CCur(0))



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..