DecimalPlaces Property

  • Thread starter Thread starter James Napolitano
  • Start date Start date
J

James Napolitano

Is their a way to set the DecimalPlaces property in code
when appending a field object?
Thanks.
 
James said:
Is their a way to set the DecimalPlaces property in code
when appending a field object?
Click to expand...

Yes, but since that's one of the Access custom properties
(as opposed to the Jet builtin properties), you have to
create the property yourself.

Here's some code that does this for the Caption property:

Set dbCur = CurrentDb()
Set tdf = dbCur.TableDefs("ZZZ")
Set fld = tdf.CreateField("MyField", dbLong)
tdf.Fields.Append fld
Set prp = fld.CreateProperty("Caption",dbText,"abc")
fld.Properties.Append prp
fld.Properties.Refresh
tdf.Fields.Refresh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invalid Operation when creating TableDef 5
Adding Fields property DecimalPlaces using the fields collection 9
Limited field properties? 4
Setting Decimal Places value at form open 1
Formatting Number in Query View 1
Ivalid operation 3219 using CreateProperty method 2
Property Format and DecimalPlaces 2
Re Code Help Please 1

Back
Top