Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Symbol Format Question
Lee Shastid 
    
22 hours ago
If I have a field and in the text box of that field I want whatever number in that box to show inches. How can I do that or can you point me to a video to learn. Example if 1.25, in the box I want it show 1.25"
Darrin Harris  @Reply  
     
19 hours ago
Hi Lee

You could use the on current event on the form

txtbox = field & """"
Donald Blackwell  @Reply  
       
14 hours ago
Hi Lee, if you just want the text box to display the quote without actually adding it to the data, you could just use the format property of the text box:

Format: @ /";

This is in the form property dialog, you don't even need vba for it. In case it isn't showing up, that's the at-sum symbol @ followed by a space, the forward slash and just one double quote then a semi-colon. The space is optional if you do or don't want it for your display.

If you do use this approach, you would need to add it in every form or report you wanted to see that in or you can add it to the format property of the field in the table.

And of course, Richard has videos on using format:

Format
Text Box Hints

to name just a couple.

In essence, if the text box is displaying a text value (or number stored as text) anything you place in the format property before a semicolon will be displayed along side the text you enter as long as the @ symbol is included. If you omit the @ symbol then whatever you put in the format property will be displayed regardless of what is entered unless the field has focus. After the semi-colon you can enter something to display if the field is null.

Lee Shastid OP  @Reply  
    
13 hours ago
Thank you for your advise. I will give it a try.
Kevin Robertson  @Reply  
          
12 hours ago
Donald It needs to be a backslash, not a forward slash.
Lee Shastid OP  @Reply  
    
11 hours ago
Thank you Kevin. I been struggling trying to figure what I was doing wrong. That solved it. Thank you
Donald Blackwell  @Reply  
       
10 hours ago
Sorry bout that, typod the slash and then spelled it out from what I typed .

Thanks for straightening it out foe him kevin
Add a Reply Upload an Image
Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/20/2026 9:46:54 PM. PLT: 0s