Go Premium for a chance to win a PS4. Enter to Win


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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

886 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