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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to convert text field with numbers to number field?

Status
Not open for further replies.
holgar

holgar

Technical User
Oct 29, 2003
14
DK
Hi,
I have a table with a field witch has text property. This is a lookup field witch contains article prices like
63.4173640 or .0565000. The format I want to use is either
63.417,640 or 63417,640.

Thanks
 
Sort by date Sort by votes
I found the answer.
Me!CostPrice = Me!cboProducts.Column(4) * 0.0000001 on form
is the way to get the right number format and save it to the table.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Field size limit Access 365
Replies
5
Views
636
TrekBiker
TrekBiker
JayRo71
  • Locked
  • Question
Saved Imoorts problem with file name
Replies
10
Views
284
Andrzejek
Andrzejek
monkeysee
  • Locked
  • Question
Field to count specific records
Replies
3
Views
179
dhookom
dhookom
MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
230
SkipVought
S
ameedoo3000
  • Locked
  • Question
Send a message to an email
Replies
2
Views
499
ameedoo3000
ameedoo3000

Part and Inventory Search

Sponsor

Back
Top