Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Report, convert Text to Value

    In Report,

    How can I convert Text to value?

  2. #2
    Join Date
    Feb 2004
    Location
    Irving, TX (Dallas, Fort Worth)
    Posts
    379

    Which

    Which type of Value, numeric, character, etc.?

    There are several conversions, will help to know which you need?

    DBS4M

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    use the appropriate coversion functions built into access/VBA
    eg
    cint(myvar)
    cstr(myvar)
    cbdl(myvar)

    alternatively, and here's something really radical, open a form in design mode, view the code and press F1 - type in the word convert and y'never know you may find out something inthe list box called type conversion functions (it came out as result 2 in Access XP).

Posting Permissions

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