Jump to content

Formatting within a Calculation field


This topic is 8454 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello

Need to know is it possible to format the data within a calculation field? If so this, this is what I'd like to have happen is for consistant text to be left justified and the data to display right justified/ tabbed aligned somehow!. Below is the current calc.

"Title: " & Title & "

Link to comment
Share on other sites

The easiest way to handle this is to use Merge Fields.

1. Create a text field named Title, and a number field for

NmbrOfPages

2. Create a script to set the value of NmbrOfPages. This script should be incorporated into other scripts to control when the update should occur.

Script: Determine Number of Pages

Freeze Window

Enter Preview Mode {}

Go to Record/Request/Page (Last)

SetField [ "Nmber of Pages", Status (CurrentPageNumber)]

Enter Browse Mode []

Refresh Window []

3. In layout mode turn on Text Ruler, then using the Text tool, type the following two lines:

Title:[tab character]<<Title>>

Number of Pages{Tab]<<Nmber of Pages>>

4. Select the first line with the text tool and set a Left tab stop in the text ruler, adjusting to where you want the Title to begin within the sentence.

5. Select the second line and set a Right tab stop where you want the last digit of the Nnber of Pages to end.

6. Adjust where the lines begin by adjusting the margin stops.

Format the text as you see fit.

Link to comment
Share on other sites

This topic is 8454 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.