Results 1 to 3 of 3
  1. #1
    Grooz13 is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    97

    Having text appearing automacticly next to numbers in a textbox

    Ok i have a field who represents hours or the square feet, is there a way that next to my let's say 3, the text "hrs" would appear.



    I knew how to do it on excel but not on access

    ex: 2 sqr² or 3 hrs

  2. #2
    ryan1313 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    20
    If you were looking to do it via vba, you can add an ubound text box and in the On Current event set the ubound text box to what you want.

    Just replace txtUnbound with whatever you rename it and YourHourFIEld to be the name of the bound field that has the hours.

    Me.txtUnbound = Me.YourHourField & "hrs"

    Ryan

  3. #3
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    you also need to have two fields. it is not good practice for one field to share two purposes for data

    you should use two, and if always leave one blank depending on what the record's data calls for

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Convert text to numbers
    By Mclaren in forum Programming
    Replies: 2
    Last Post: 05-02-2010, 01:36 PM
  2. Convert text to numbers
    By randolphoralph in forum Access
    Replies: 1
    Last Post: 03-21-2010, 10:33 AM
  3. Report TextBox printing ID Number, not text
    By ZipDoc in forum Reports
    Replies: 8
    Last Post: 02-01-2010, 12:30 PM
  4. Replies: 3
    Last Post: 03-28-2009, 06:06 PM
  5. Keeping text in a report textbox
    By Hawkx1 in forum Reports
    Replies: 2
    Last Post: 11-13-2008, 04:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums