Solved

Print

Posted on 2009-07-05
2
158 Views
Last Modified: 2013-11-25
How to make a code wherein I want to put a limit of letters that would come out upon  printing?
My code is...  Print #1, Trim(!pname)
example on my !pname is.. Amoxicillin 500mg cap (amixil brand)
In printing, I want only Amoxillin 500mg or I want only 15 char that will come out on priting
Thanks!
0
Comment
Question by:Whing Dela Cruz
2 Comments
 
LVL 5

Accepted Solution

by:
rizwanidrees earned 250 total points
ID: 24779115
Print #1, Left(Trim(!pname),15)
0
 

Author Closing Comment

by:Whing Dela Cruz
ID: 31599881
Thank you so much! More Power to you!
0

Featured Post

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question