|
| |
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
 |
change to standard format - 1/29/2006 12:00:44
Set tbl = db.TableDefs("Invoice")
tbl.Fields.Append tbl.CreateField("amount", dbCurrency)
the above code is working well.
However, the below code, I cannot change the format (standard), no dollar sign.
tbl.Fields("amount").Properties("Format") = "Standard"
The message said that "property no found"
What's wrong with it?
How can I change the format (standard)?
Please let me know, thanks.
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
