Place holder for blank fields? 
Author Message
 Place holder for blank fields?

I think I know the answer to this, but FM has surprised me before, so here
goes.

Is there a way to insert a null character in blank fields without making
every field a calc field?  In my line of research, it is important for EVERY
field to have some kind of mark, so users know if a 0 means "zero", rather
than "that particular piece of data doesn't exist".  Similarly, blanks might
convey that the data doesn't exist OR the data input person accidently
skipped that field.  I'm thinking a bullet, asterisk, something like that.

So, how 'bout it?  

Fred

As I was typing this, it suddenly occurred to me that one could
automatically enter bullets upon creation of a new record which would then
be overwritten upon data entry.  That would work for all future records,
though I'd have to do it manually for all current fields which is unwieldly
to say the least!  Anyway, how would that solution work?  Will this cause
problems if the field is designated as "number"?  What about calcs that are
not to evaluate if all fields are empty?  Zeros would all be entered there.
Hmmm...



Mon, 21 Mar 2005 21:33:57 GMT
 Place holder for blank fields?

I think you just go into options for the field in define fields, and under
auto enter select auto enter calculation, and you can have anything you want
be the initial value.


Quote:
> I think I know the answer to this, but FM has surprised me before, so here
> goes.

> Is there a way to insert a null character in blank fields without making
> every field a calc field?  In my line of research, it is important for
EVERY
> field to have some kind of mark, so users know if a 0 means "zero", rather
> than "that particular piece of data doesn't exist".  Similarly, blanks
might
> convey that the data doesn't exist OR the data input person accidently
> skipped that field.  I'm thinking a bullet, asterisk, something like that.

> So, how 'bout it?

> Fred

> As I was typing this, it suddenly occurred to me that one could
> automatically enter bullets upon creation of a new record which would then
> be overwritten upon data entry.  That would work for all future records,
> though I'd have to do it manually for all current fields which is
unwieldly
> to say the least!  Anyway, how would that solution work?  Will this cause
> problems if the field is designated as "number"?  What about calcs that
are
> not to evaluate if all fields are empty?  Zeros would all be entered
there.
> Hmmm...



Mon, 21 Mar 2005 21:40:06 GMT
 Place holder for blank fields?

Quote:

> Is there a way to insert a null character in blank fields without making
> every field a calc field?  In my line of research, it is important for EVERY
> field to have some kind of mark, so users know if a 0 means "zero", rather
> than "that particular piece of data doesn't exist".  Similarly, blanks might
> convey that the data doesn't exist OR the data input person accidently
> skipped that field.  I'm thinking a bullet, asterisk, something like that.

> So, how 'bout it?  

> Fred

> As I was typing this, it suddenly occurred to me that one could
> automatically enter bullets upon creation of a new record which would then
> be overwritten upon data entry.  That would work for all future records,
> though I'd have to do it manually for all current fields which is unwieldly
> to say the least!  Anyway, how would that solution work?  Will this cause
> problems if the field is designated as "number"?  What about calcs that are
> not to evaluate if all fields are empty?  Zeros would all be entered there.
> Hmmm...

Use the Replace function.
First do a Find for empty fields by entering Find mode and placing an
equals sign ("=" without the quotes) in the field in question and then
perform the find. Then in the found set, enter the null character and
use the Replace function to copy it to all the other records. If you
have a lot of fields that need this do it with a script.

You can put non numeric characters in a number fields they should be
ignored by any calculations or summaries based on the field.

--

Blue & White G3/400MHz MacOS 9.1, Starmax 3000/200MHz MacOS 8.6
If I ever talk about switching to Windows, will someone please beat me with
a Windows for Dummies book till the urge passes?



Tue, 22 Mar 2005 03:28:34 GMT
 Place holder for blank fields?
Fred,

one trick is to use two fields, one data entry and one calc:
(Case(data entry = "", "no data entered",
not IsEmpty(data entry), data entry)

make the data field no fill, and text invisible (same colour as background,...)
and place it on top of the calc

--
regards

Chris

Chris Brown
Dept. Neurosurgery
University of Adelaide

Quote:

> I think I know the answer to this, but FM has surprised me before, so here
> goes.

> Is there a way to insert a null character in blank fields without making
> every field a calc field?  In my line of research, it is important for EVERY
> field to have some kind of mark, so users know if a 0 means "zero", rather
> than "that particular piece of data doesn't exist".  Similarly, blanks might
> convey that the data doesn't exist OR the data input person accidently
> skipped that field.  I'm thinking a bullet, asterisk, something like that.

> So, how 'bout it?

> Fred

> As I was typing this, it suddenly occurred to me that one could
> automatically enter bullets upon creation of a new record which would then
> be overwritten upon data entry.  That would work for all future records,
> though I'd have to do it manually for all current fields which is unwieldly
> to say the least!  Anyway, how would that solution work?  Will this cause
> problems if the field is designated as "number"?  What about calcs that are
> not to evaluate if all fields are empty?  Zeros would all be entered there.
> Hmmm...



Tue, 22 Mar 2005 08:56:18 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Empty datafield full of place holders

2. Place holders

3. place holder vs. summary column

4. Print Blanks in place of Zeros

5. How do I place the value of another field in a field :)

6. Blank field not space in char and varchar field

7. Copying multiple fields into the next blank field(s)

8. money field and decimal places

9. Physical Files in place of Image data fields

10. Format money field to 2 decimal places

11. Decimal Places in a DBASE field

12. The use of two fields on one particular place in a Form


 
Powered by phpBB® Forum Software