Field to convert Decimal to Hex

Posted on 2001-06-26
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Accepted Solution

TheMek earned 40 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

728 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