Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro problem...

Status
Not open for further replies.
Joshy

Joshy

Programmer
Mar 8, 2001
14
0
0
CA
Hi. I'm trying to set the 'format' and 'decimal' property for a field ("number" type) of a table using macro, so that I can round off decimals places. Does anyone know what action I use? I think its probably one of the many build-in functions in the "run-code" action, but which one?
table name is [tbl_HouseData] and fields [temp1], [temp2]...
thanks :)
 
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
153
dhookom
dhookom
Moss100
  • Locked
  • Question
Using data macro to alert user when record is added to a table.
Replies
2
Views
54
Andrzejek
Andrzejek
LondonJohn
  • Locked
  • Question
Problem using Access 2003 and 2007 for the same database
Replies
4
Views
149
LondonJohn
LondonJohn
notconfident
  • Locked
  • Question
Upgrade from Access 2007 to 2010 problem with a Query
Replies
5
Views
67
notconfident
notconfident
Skittle
  • Locked
  • Question
RunSavedImportExport Macro - How Can You Edit Definition?
Replies
1
Views
52
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top