Improve company productivity with a Business Account.Sign Up


Field to convert Decimal to Hex

Posted on 2001-06-26
Medium Priority
Last Modified: 2006-11-17
I want to create a field in my database, that will automatically convert a decimal value (from another field) to the equivalent Hex value.

Question by:Cuong
  • 2

Accepted Solution

TheMek earned 160 total points
ID: 6227224
Hi Cuong,

I don't think this is possible at table-level, but if you base a form on the respective table, you can set the controlsource to
= Hex([YourDecimalField])
to get the desired hexadecimal value.
Another option is to update the hexadecimal field in the after-update event of the decimal field (works with the same Hex function).
Hope this helps,
LVL 12

Expert Comment

ID: 6228019
What is the database?  Do you intend to store the hex value as a string, otherwise, binary=hex=octal=decimal.
LVL 12

Expert Comment

ID: 6228022
Sorry, I know it's Access, but I meant to ask what version.

Author Comment

ID: 6230506
Cheers! Done it now!

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question