Problem with concatenated text fileld

[sheltieuk]

Hi all,

I was hoping someone could help with the following problem I have encountered, I have 4 text fields that I have concatenated into a 5th calculated text field- all the fields have the text formatted to title case. On some of the records the calc field is displaying correctly with all the text in title case and on some records the first half of the calc field is displaying ok but the second half is displaying in lower case. any suggestion please.

I am using FM7 and WinXP Pro

many thanks

RayC

[Fitch]

Post your calc and I'll take a look.

[aklodner]

Just one other quick question, are the fields formatted to Titlecase? If so, this does not necessarily mean the data, text, was entered in titlecase. To ensure that titlecase is enforced in your calc, you could do something like this:

TextStyleAdd(field1; Titlecase) & " - " & TextStyleAdd(field2; Titlecase) & " - " & TextStyleAdd(field3; Titlecase)& " - " & TextStyleAdd(field4; Titlecase)

The hyphens are optional, use whatever your using in your concatenation. What this calc will do is make the data titlecase, regardless of the way it was entered in the original fields.

HTH

Adam

[sheltieuk]

Hi Fitch,

The calculation I'm using is as follows: -

Sex & " - " & Date of Birth & " - " & sires & " - " & dam & " - " & owner 2

A further thing I've discovered since my original post is that the field displays correctly in the master file, it is only when displayed using a relationship that the incorrect display occurs.

RayC

[Fitch]

Any formatting you apply on a layout won't carry over into calculations or related files. A simple fix is to enclose the whole calc in a Proper() function like so:

Proper( Sex & " - " & Date of Birth & " - " & sires & " - " & dam & " - " & owner 2 )

[sheltieuk]

Many thanks Tom I've tried your suggestion and my problem is now solved.

RayC