How to limit number of characters

[jennpade]

I am successfully using the web companion to publish a database on the web (using a custom HTML page).

However, I would like to limit the number of characters that display in a one of the FMP text fields on that web page.

How can I do this? Is it something that I do in the HTML or can I set it up in the database itself?

[dspires]

An example:

Operation: <INPUT TYPE="text" Name="Operation" Size=20>

[yafreax]

actually that won't limit the number of characters, just what can be seen at one time. If that 's all you need to do, more power to you. But to actually limit what the user can input, use the following:

<INPUT TYPE="text" Name="FIeldName" Size=20 MAXLENGTH="20">

If you are trying to limit a field that is read only so the user only sees a portion, then i believe you will have to have a seperate field in your DB with the following calc:

Left(FieldName, 20)

With 20 being how many characters you want to be visible. Then in the CDML, of course the tag would be [FMP-Field: cLimitField].

Hope this helps

Jeremy