FONT Q - Without having programmatic access to make any changes, wow can one force what is printed to print in all UPPERER case characters (in all caps)? [modified]
-
**NOTE:**I don't think this is technically a programming question but if it is please advise and I will re-post elsewhere. THE GOAL: The accounting software that prints checks needs to print the payee names in UPPER CASE characters only even though those names are stored (in the database the app uses) as proper case. THE LIMITATIONS and PROBLEM(s): No programmatic access to application so any solution must be done outside the application such as using an all caps only font. POSSIBLE IDEA(S): (What I have so far) 1) FONT – Use a font that auto converts all characters to their upper case equivelant. This would allow for storing in any case but printing in all caps. The problem is does such a font exists and if yes can it produce commonly used business fonts like ARIAL or courier? 2) OTHER??? NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing. Thoughts? Suggestions?
modified on Monday, May 23, 2011 11:50 AM
YSLGuru wrote:
NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing.
Run a SQL profile to see how the app is pulling the data out from the database, if your lucky its using a Stored Proceedure or View that is not shared with anything else. Modify that object to return UPPER().
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
-
YSLGuru wrote:
NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing.
Run a SQL profile to see how the app is pulling the data out from the database, if your lucky its using a Stored Proceedure or View that is not shared with anything else. Modify that object to return UPPER().
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
-
I think simply changing the font is your best bet. There are lots of all-upper-case fonts. Here's[^] a link to MyFonts where you can buy one. I've simply selected "All Caps" using the tag search. Make sure you check the full character set, though, because some that look great at first may have one or two letters that aren't quite what you expect. Cheers, Drew.
I think so to but I wanted to solicit input in case I had no thought of another option and more importantly to get susggestions on where to fiund a font likie this. I ahev contacted the poeple at the site you recomeneded. Now I just hope they have a font like this that prints like ARIAL or COURIER NEW and my problems are solved. Thanks
-
I think so to but I wanted to solicit input in case I had no thought of another option and more importantly to get susggestions on where to fiund a font likie this. I ahev contacted the poeple at the site you recomeneded. Now I just hope they have a font like this that prints like ARIAL or COURIER NEW and my problems are solved. Thanks
-
**NOTE:**I don't think this is technically a programming question but if it is please advise and I will re-post elsewhere. THE GOAL: The accounting software that prints checks needs to print the payee names in UPPER CASE characters only even though those names are stored (in the database the app uses) as proper case. THE LIMITATIONS and PROBLEM(s): No programmatic access to application so any solution must be done outside the application such as using an all caps only font. POSSIBLE IDEA(S): (What I have so far) 1) FONT – Use a font that auto converts all characters to their upper case equivelant. This would allow for storing in any case but printing in all caps. The problem is does such a font exists and if yes can it produce commonly used business fonts like ARIAL or courier? 2) OTHER??? NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing. Thoughts? Suggestions?
modified on Monday, May 23, 2011 11:50 AM
-
YSLGuru wrote:
Thoughts?
Examine the requirement itself. What drives the need that the checks must be upper case?
-
jschell wrote:
Examine the requirement itself.
What drives the need that the checks must be upper case?The Bank that manages the acct(s) that the checks are written from requires all Caps for the Payee name.
YSLGuru wrote:
The Bank that manages the acct(s) that the checks are written from requires all Caps for the Payee name.
Then presumably they have access to their code and should easily be able to modify it to force payee to upper case.
Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.
-
YSLGuru wrote:
The Bank that manages the acct(s) that the checks are written from requires all Caps for the Payee name.
Then presumably they have access to their code and should easily be able to modify it to force payee to upper case.
Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.
Henry Minute wrote:
Then presumably they have access to their code and should easily be able to modify it to force payee to upper case.
If by "they" you mean the Bank then no they don't have that kind of access. We use an accounting software application to manage financials with and we deal with hundreads of banks, each with 1 or more acounts. One of thes banks is saying the Payee Name must be in all caps if we are going to sue a certain feature th ebank offers. Not every bank we deal wioth has this All Caps requirement. As far as the sofwtare vendor making teh change, that woudl be an expensive change at best assuminmg they'd consider it. Hopefully the custom font will work out. Thanks
-
**NOTE:**I don't think this is technically a programming question but if it is please advise and I will re-post elsewhere. THE GOAL: The accounting software that prints checks needs to print the payee names in UPPER CASE characters only even though those names are stored (in the database the app uses) as proper case. THE LIMITATIONS and PROBLEM(s): No programmatic access to application so any solution must be done outside the application such as using an all caps only font. POSSIBLE IDEA(S): (What I have so far) 1) FONT – Use a font that auto converts all characters to their upper case equivelant. This would allow for storing in any case but printing in all caps. The problem is does such a font exists and if yes can it produce commonly used business fonts like ARIAL or courier? 2) OTHER??? NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing. Thoughts? Suggestions?
modified on Monday, May 23, 2011 11:50 AM
Use a different daisy wheel. Use
set term/perm/nolowercaseon the printer. Well, those used to work. :~ I think you should contact the vendor and see whether or not there's a built-in way to do that. -
**NOTE:**I don't think this is technically a programming question but if it is please advise and I will re-post elsewhere. THE GOAL: The accounting software that prints checks needs to print the payee names in UPPER CASE characters only even though those names are stored (in the database the app uses) as proper case. THE LIMITATIONS and PROBLEM(s): No programmatic access to application so any solution must be done outside the application such as using an all caps only font. POSSIBLE IDEA(S): (What I have so far) 1) FONT – Use a font that auto converts all characters to their upper case equivelant. This would allow for storing in any case but printing in all caps. The problem is does such a font exists and if yes can it produce commonly used business fonts like ARIAL or courier? 2) OTHER??? NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing. Thoughts? Suggestions?
modified on Monday, May 23, 2011 11:50 AM