Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #2234 > unrolled thread

Borders

Back to article view | Back to comp.databases.filemaker

Contents

  Borders csampson@inetworld.net (Charles H. Sampson) - 2015-04-25 18:54 -0700
    Re: Borders Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-04-26 14:00 +1200
      Re: Borders csampson@inetworld.net (Charles H. Sampson) - 2015-04-27 23:06 -0700
        Re: Borders Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-04-28 18:38 +1200
    Re: Borders csampson@inetworld.net (Charles H. Sampson) - 2015-05-08 12:50 -0700
      Re: Borders Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-05-09 09:58 +1200
        Re: Borders Thibaud Taudin Chabot <tchabot@hccnet.nl> - 2015-05-09 07:38 +0200

#2234 — Borders

What's the trick with borders? I've got layouts that I created with
borders around fields uneventfully. I've also got a couple where there
are fields -- somtimes only some fields -- that have no border and I'm
unable to put a border around them. I'm looking at one right now where
four of the five fields have borders around them. I go to layout mode,
select the field, go to Format -> Field/Control -> Borders and all four
border boxes -- Top, Bottom, Left, Right -- are checked. The pull-down
list is on Borders. Going back to Browse and there are no borders. I
even tried unchecking the four boxes (I'm an experienced programmer and
I know lots of ways a program can get go wring while running,), No
change.

???

Charlie
-- 
Nobody in this country got rich on his own.  You built a factory--good.
But you moved your goods on roads we all paid for.  You hired workers we
all paid to educate. So keep a big hunk of the money from your factory.
But take a hunk and pay it forward.  Elizabeth Warren (paraphrased)

[toc] | [next] | [standalone]

#2235

In article <1m3g6lv.10ue4iznysxglN%csampson@inetworld.net>, Charles H.
Sampson <csampson@inetworld.net> wrote:

> What's the trick with borders? I've got layouts that I created with
> borders around fields uneventfully. I've also got a couple where there
> are fields -- somtimes only some fields -- that have no border and I'm
> unable to put a border around them. I'm looking at one right now where
> four of the five fields have borders around them. I go to layout mode,
> select the field, go to Format -> Field/Control -> Borders and all four
> border boxes -- Top, Bottom, Left, Right -- are checked. The pull-down
> list is on Borders. Going back to Browse and there are no borders. I
> even tried unchecking the four boxes (I'm an experienced programmer and
> I know lots of ways a program can get go wring while running,), No
> change.
> 
> ???

Check that the border colour is not set to transparent or white (or
whatever the background colour of your layout is).

Also before you go to the Borders window, make sure you've selected the
appropriate field(s) you want to format. Changing the options with no
field(s) selected will set the default for any new fields added to the
Layout, but it won't change fields already on the Layout.

Helpful Harry  :o)

[toc] | [prev] | [next] | [standalone]

#2236

Helpful Harry <HelpfulHarry@BusyWorking.com> wrote:

> In article <1m3g6lv.10ue4iznysxglN%csampson@inetworld.net>, Charles H.
> Sampson <csampson@inetworld.net> wrote:
> 
> > What's the trick with borders? I've got layouts that I created with
> > borders around fields uneventfully. I've also got a couple where there
> > are fields -- somtimes only some fields -- that have no border and I'm
> > unable to put a border around them. I'm looking at one right now where
> > four of the five fields have borders around them. I go to layout mode,
> > select the field, go to Format -> Field/Control -> Borders and all four
> > border boxes -- Top, Bottom, Left, Right -- are checked. The pull-down
> > list is on Borders. Going back to Browse and there are no borders. I
> > even tried unchecking the four boxes (I'm an experienced programmer and
> > I know lots of ways a program can get go wring while running,), No
> > change.
> > 
> > ???
> 
> Check that the border colour is not set to transparent or white (or
> whatever the background colour of your layout is).
> 
> Also before you go to the Borders window, make sure you've selected the
> appropriate field(s) you want to format. Changing the options with no
> field(s) selected will set the default for any new fields added to the
> Layout, but it won't change fields already on the Layout.

To the rescue once again, Harry. The default settings were to use white
lines. Better said, they were to use white non-lines, because the
default setting for line thickness was "no line". I must have changed
the defaults by accident while I was fumbling around. I'm up and running
on this count.

I can't pass up this opportunity to grouse about another bit of
FileMaker's user unfriendliness. I select an object, I navigate into the
dialogue to set the borders of that object, I check boxes that seem to
indicate that I want borders on all four sides, and FM says, "Got it. Of
course you want white lines on a white background, except that you
really don't want lines at all." Really? At the least, I'd expect a
warning about setting borders to "no line". The white-on-white might be
a bit trickier to detect and warn about.

Charlie
-- 
Nobody in this country got rich on his own.  You built a factory--good.
But you moved your goods on roads we all paid for.  You hired workers we
all paid to educate. So keep a big hunk of the money from your factory.
But take a hunk and pay it forward.  Elizabeth Warren (paraphrased)

[toc] | [prev] | [next] | [standalone]

#2237

In article <1m3k7qq.14c1rdo13vo09wN%csampson@inetworld.net>, Charles H.
Sampson <csampson@inetworld.net> wrote:
> Helpful Harry <HelpfulHarry@BusyWorking.com> wrote:
> > In article <1m3g6lv.10ue4iznysxglN%csampson@inetworld.net>, Charles H.
> > Sampson <csampson@inetworld.net> wrote:
> > > 
> > > What's the trick with borders? I've got layouts that I created with
> > > borders around fields uneventfully. I've also got a couple where there
> > > are fields -- somtimes only some fields -- that have no border and I'm
> > > unable to put a border around them. I'm looking at one right now where
> > > four of the five fields have borders around them. I go to layout mode,
> > > select the field, go to Format -> Field/Control -> Borders and all four
> > > border boxes -- Top, Bottom, Left, Right -- are checked. The pull-down
> > > list is on Borders. Going back to Browse and there are no borders. I
> > > even tried unchecking the four boxes (I'm an experienced programmer and
> > > I know lots of ways a program can get go wring while running,), No
> > > change.
> > > 
> > > ???
> > 
> > Check that the border colour is not set to transparent or white (or
> > whatever the background colour of your layout is).
> > 
> > Also before you go to the Borders window, make sure you've selected the
> > appropriate field(s) you want to format. Changing the options with no
> > field(s) selected will set the default for any new fields added to the
> > Layout, but it won't change fields already on the Layout.
> 
> To the rescue once again, Harry. The default settings were to use white
> lines. Better said, they were to use white non-lines, because the
> default setting for line thickness was "no line". I must have changed
> the defaults by accident while I was fumbling around. I'm up and running
> on this count.

Sorry, line thickness is another one I forgot to mention to check.




> I can't pass up this opportunity to grouse about another bit of
> FileMaker's user unfriendliness. I select an object, I navigate into the
> dialogue to set the borders of that object, I check boxes that seem to
> indicate that I want borders on all four sides, and FM says, "Got it. Of
> course you want white lines on a white background, except that you
> really don't want lines at all." Really? At the least, I'd expect a
> warning about setting borders to "no line". The white-on-white might be
> a bit trickier to detect and warn about.

That's not really a FileMaker issue. The same happens in many other
applications - Word, Excel, PowerPoint, InDesign, Clarisworks, Numbers,
Pages, Keynote, ...

The applications also can't really understand what you're doing. You
might want to have a white background and set a field border to white,
because you're then going to move it onto or draw behind it a rectangle
filled with a different colour. Or maybe the field is sitting half on a
black rectangle and half on a white background, so how does the
application decided whether white or black borders are "wrong"?

Line thickness of "No Line" (or in some applications "0") is a rather 
silly option ... although it does mean lazy people can simply set the
line thickness to "no line" instead of actually turning off the four
border options or setting the colour to transparent / no colour.


Helpful Harry  :o)

[toc] | [prev] | [next] | [standalone]

#2315

Follow-up. I used the white-on-white technique, which Helpful Harry
pointed out could be useful, in another context. I have a table in Word
that has a couple of cells that have the value 0 in them. This is
because I want to sum the numbers in those cells'  column and Word won't
sum past a blank. It's always irritated me to see those "pointless"
zeros sitting there. I formatted the text to be white (on the white
background). The zeros are still there but they're not visible now.

Charlie
-- 
Nobody in this country got rich on his own.  You built a factory--good.
But you moved your goods on roads we all paid for.  You hired workers we
all paid to educate. So keep a big hunk of the money from your factory.
But take a hunk and pay it forward.  Elizabeth Warren (paraphrased)

[toc] | [prev] | [next] | [standalone]

#2316

In article <1m43ss4.47rpi6adeebkN%csampson@inetworld.net>, Charles H.
Sampson <csampson@inetworld.net> wrote:
> 
> Follow-up. I used the white-on-white technique, which Helpful Harry
> pointed out could be useful, in another context. I have a table in Word
> that has a couple of cells that have the value 0 in them. This is
> because I want to sum the numbers in those cells'  column and Word won't
> sum past a blank. It's always irritated me to see those "pointless"
> zeros sitting there. I formatted the text to be white (on the white
> background). The zeros are still there but they're not visible now.

I'm not sure about Word or whatever version your using (I've never
bothered to have tables that include formulas), but in Excel you can
either:

    - change the cell's number format to not display a zero,

or  - conditionally format the cell to display zeros as
      white, and other numbers in black (or whatever colour),

or  - use a cell formula with an If statement instead of just 
      the standard Sum function so that it doesn't show zero
      totals.
      i.e.   If (Sum(range) = 0 , "", Sum(Range))


Helpful Harry  :o)

[toc] | [prev] | [next] | [standalone]

#2317

Helpful Harry schreef op 8-5-2015 om 23:58:
> In article <1m43ss4.47rpi6adeebkN%csampson@inetworld.net>, Charles H.
> Sampson <csampson@inetworld.net> wrote:
>>
>> Follow-up. I used the white-on-white technique, which Helpful Harry
>> pointed out could be useful, in another context. I have a table in Word
>> that has a couple of cells that have the value 0 in them. This is
>> because I want to sum the numbers in those cells'  column and Word won't
>> sum past a blank. It's always irritated me to see those "pointless"
>> zeros sitting there. I formatted the text to be white (on the white
>> background). The zeros are still there but they're not visible now.
>
> I'm not sure about Word or whatever version your using (I've never
> bothered to have tables that include formulas), but in Excel you can
> either:
>
>      - change the cell's number format to not display a zero,
>
> or  - conditionally format the cell to display zeros as
>        white, and other numbers in black (or whatever colour),
>
> or  - use a cell formula with an If statement instead of just
>        the standard Sum function so that it doesn't show zero
>        totals.
>        i.e.   If (Sum(range) = 0 , "", Sum(Range))
>
>
> Helpful Harry  :o)
>
in Excel there is also a general option to hide the 0 (advanced tab in 
options)

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.filemaker

csiph-web