• Convert data type from text into number

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Convert data type from text into number

    Author
    Topic
    #468232

    In the design view of my table called “products” i can convert easily the data type form text into code. I need however to convert it through code in order to automate the function.Can you help me with the solution, how can i convert the data type of the field ” code” to be number instead of text?

    Viewing 1 reply thread
    Author
    Replies
    • #1218867

      Look up “Type Conversions functions” in help. You’ll find cint (for converting to integers), cdbl (for converting to doubles), etc.

    • #1218870

      Thank you !

    Viewing 1 reply thread
    Reply To: Convert data type from text into number

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: