Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2011
    Location
    Ireland
    Posts
    31

    Unanswered: Option Group Values

    Hi All,
    I'm trying to set a value in an option group to 2.5 but it keeps getting rounded down to 2. I've got the field properties for the underlying table set to Decimal. Any ideas what i'm doing wrong ?

    Thanks,
    Pol

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I'd guess the option group control can only accept an integer value. So you cannot use the option value to store 2.5 or any other non integer.
    so you need to rethink your process
    either internally translate the option value into the value ranges you want by placing some VBA code that sets the appropriate value and reads/writes back the appropriate value if any changes have been made.

    probably the easiest would be to use another table and use say a list or combo box to represent that value.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2011
    Location
    Ireland
    Posts
    31
    Ok thanks for your help....think i'll go the combo box route.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •