Text Formatting issue

[pali]

hi all
i have a text formatting issue.
In report i want to show the text coming from database in Capitilization format irrespective of its case(lower, upper or mixture of both) in database.
for example data in database is like
SALES MANAGER then it should display Sales Manager in report.
Is there any way to do it.
thanks in advance.

[MFGF]

I'm not aware of any formatting options to do this, but as an alternative, for each item, change the expression property to use the upper() function

eg change the expression

[gosales_goretailers].[Sales reps].[First name]

to

upper([gosales_goretailers].[Sales reps].[First name])

Best regards,

MF.

[pali]

the solution you have given will change the case of text to upper but i want only first letter of each word to be capital.
any more suggestions

[MFGF]

Sorry - I should have looked more closely at your question (shame on me!)

You could either code a more complex expression that looks for spaces in the string then substitutes the first character after each space with uppercase, or (probably preferably) look at building this code into the database and calling it via a stored procedure or a database function, although this would require modelling changes in Framework manager too.  For ideas on the code, take a look at http://www.mvps.org/access/strings/str0008.htm.

Regards,

MF.

[pali]

hi
don't you think it will be too complex for each and every text attribute.
Is there any direct method or option in reportnet to achieve that.