If you have Provision and the field is not attached to some write trigger,
you could create a simple procedure to go through all the Part Master
records and convert the field to all caps. I don't think you can force a
user defined field, but you could save and run your procedure once a night
and correct any that have been entered for that day to all CAPS. If it was
a VBForm field, you could attach a procedure to the OK button to convert the
VBForm field to caps.
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, April 24, 2003 2:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Make Uppercase in User Defined Field
We have a user defined field on our Part Master which is used for the
Customer ID of the primary customer for the part. The secretary that has
been entering them on parts all day neglected to turn the caps lock on. Is
there any way, such as in Word with Ctrl-Shift-A, to convert selected text
to all caps? It would really save her a ton of time re-entering them to
just pull up the UD screen and upcase them (it's in 1st field on form).
Also, any way to force user defined field data to be all caps on entry?
Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co
PS - Sorry if this is a repeat. Yahoo disabled my group account due to spam
filtering bouncing messages (now fixed).
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
you could create a simple procedure to go through all the Part Master
records and convert the field to all caps. I don't think you can force a
user defined field, but you could save and run your procedure once a night
and correct any that have been entered for that day to all CAPS. If it was
a VBForm field, you could attach a procedure to the OK button to convert the
VBForm field to caps.
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, April 24, 2003 2:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Make Uppercase in User Defined Field
We have a user defined field on our Part Master which is used for the
Customer ID of the primary customer for the part. The secretary that has
been entering them on parts all day neglected to turn the caps lock on. Is
there any way, such as in Word with Ctrl-Shift-A, to convert selected text
to all caps? It would really save her a ton of time re-entering them to
just pull up the UD screen and upcase them (it's in 1st field on form).
Also, any way to force user defined field data to be all caps on entry?
Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co
PS - Sorry if this is a repeat. Yahoo disabled my group account due to spam
filtering bouncing messages (now fixed).
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/