Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


Number Format with MySQL Linked Table

Number Format with MySQL Linked Table

Hello.....I have a linked table through ODBC with a MySQL database. Any of the number fields are returned without the decimal place. For example 1,000.01 is stored in MySQL as 100001.

My question is what is the best approach to work with these values in Access Forms? If I do any conversion of the values in a query it makes the field not editable since it is based on an expression. Is there any way to simply display the field properly even though the user would have to enter data without the decimal?

Thanks in advance.

RE: Number Format with MySQL Linked Table


You would display Value/100.

After the use enters a decimal like 100 or 100.1 or 100.11, store ThatValue*100 in your table.


glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Number Format with MySQL Linked Table

Could you provide some direction on how this could be accomplished? The form is bound to a query which updates the record as soon as it is edited. Any way that I am aware of to 'display Value/100' would make the field based on an expression and therefore not able to be edited.

RE: Number Format with MySQL Linked Table

You would need an unbounded field to display:
[ThisField] = [FieldValue]/100

Then the user can enter some other value into [ThisField]. When the user is satisfied, hits a button and your code does
[FieldValue] = [ThisField]*100


glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close