Using Proper 
Author Message
 Using Proper
When does the Proper(text) work when validating a field?  I assumed it would
make the first word capitalized upon leaving the field.  I have the field
validated by calculation and enter the data in lowercase.  When I leave the
field, it does not capitalize the 1st letter of the word.
Any ideas???

Thanks.



Mon, 05 Mar 2001 03:00:00 GMT
 Using Proper

The Proper(text) function does not validate.  It only converts text to a
Proper format.  If you need to have the data displayed in this matter, go to
the layout, select the field and set the text format to Proper.  If you'll
need to export this data and format later, use the Proper function in a new field.

-Dave

Quote:

> When does the Proper(text) work when validating a field?  I assumed it would
> make the first word capitalized upon leaving the field.  I have the field
> validated by calculation and enter the data in lowercase.  When I leave the
> field, it does not capitalize the 1st letter of the word.
> Any ideas???

> Thanks.



Tue, 06 Mar 2001 03:00:00 GMT
 Using Proper
Seems to me that being its offered in the File, Define Fields, Options list,
it should work even during the validation.  I don't want to validate the
data unless it has initial caps (Proper).  I couldn't find the text format
option in Layout, Format, Text drop down, however I did try checking the
"Title Case" option and that seems to work.  Maybe you have version 3 and it
is different from version 4?????  Am I on the right track??

Quote:

>The Proper(text) function does not validate.  It only converts text to a
>Proper format.  If you need to have the data displayed in this matter, go
to
>the layout, select the field and set the text format to Proper.  If you'll
>need to export this data and format later, use the Proper function in a new
field.

>-Dave


>> When does the Proper(text) work when validating a field?  I assumed it
would
>> make the first word capitalized upon leaving the field.  I have the field
>> validated by calculation and enter the data in lowercase.  When I leave
the
>> field, it does not capitalize the 1st letter of the word.
>> Any ideas???

>> Thanks.



Tue, 06 Mar 2001 03:00:00 GMT
 Using Proper

Quote:


> Menu Bar:  Format / Style / Title Case  Version 3.  The only problem that
> I have with Title Case (and maybe someone else can jump in here) is that
> if I type McQueen, Title Case makes it Mcqueen.  I know there has to be a
> solution via a script.

Whomever can figure out such a script, I would appreciate it if you would post
it here. I have the same problem. Oh, and I have problems with hyphenated names
as well, like "Steven Gerio-{*filter*}" Gosh darnit! Why don't they just pick one! :D
--
   de Designers,
[Jameson Stalanthas Yu, Shade and Sweet Water, mes amis and Edgerunners]
       [Link at http://www.***.com/ ~jamesony -X- ICQ 10208399]
       [Joint Educational Project http://www.***.com/ ]
            [Mutatis mutandis, strive to be humane, not human]


Fri, 09 Mar 2001 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Using PROPER() with names

2. Proper way to change datatype from nVarChar to VarChar using T-SQL

3. Proper Case conversion using a stored procedure with an update statement - SQL7

4. dbAnywhere connection using JDBC proper

5. Proper way to catch error using ADODB?

6. Using Data Dictionary to tables with Referential Integrity in proper order

7. Can Postgres be used as proper OO database?

8. proper syntax for mysql query using count(*)

9. function for proper case?

10. Proper method for uninstalling SQL Server

11. Proper use of xp_sendmail

12. Proper jdbc driver ??


 
Powered by phpBB® Forum Software