Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    87

    Unanswered: Access: number as double in forms?

    I can set field value to be number (as double) in tables, but how do i do that for the unbound form field? I couldn't find such option in field properties...

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by YZF
    I can set field value to be number (as double) in tables, but how do i do that for the unbound form field? I couldn't find such option in field properties...
    Basically because there is no such thing - the data type at the field level is different to the formatting at the form level. All you want to do is validate your entries (use the IsNumeric function - no need to check the scale as Double is as big as it gets in Access... I think).
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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