Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

Is there a way to insert a non-breaking space in a calculation?  For example, I have a merge field in a calculation with a doctor's name.  Sometimes the text looks like this in the layout:

 

...according to the report by Dr.

James Smith.

 

or with Mr. or Mrs.:

 

...was determined to bje owned by Mr.

John Doe.

 

I'd like to keep the Dr. and the first name together on one line.  I know that in WordPerfect, for example, CTRL-Space does the trick.

 

Thanks,

Kevin

Posted

Hi, LaRetta.  Thanks again.

 

When I use CTRL-Space in the calculation, it doesn't pass to the text field.  But, I then remembered that I used to use ALT+0160 for a blank space in another program, and when I insert that into the calculation it does pass through to the text field.  Now I can keep things tidy.

 

Thanks for all your help, and have a great day.

Kevin

Posted

Cool you got it!!  No, ctrl-space works manually not in calcs.  What I mean is that, to use in a calculation,  you would concatenate similar to:

 

"your text or whatever you are typing" & Char ( 160 ) &  aField & ...

 

But just like tab which allows shift-tab (for insertion into calcs), there are alternatives.  By using Char() you can see what was inserted and I kinda like that but I don't use special characters often.

Posted

That's a great tip, LaRetta.  I changed my ALT-0160 spaces to Char ( 160 ) so I can now see what's there instead of them being invisible.  Very smart idea.

 

Kevin

This topic is 4319 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.