By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,982 Members | 1,955 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,982 IT Pros & Developers. It's quick & easy.

Input Mask:>C;; ValidationRule=In("T","F"," ") AutoTab:Yes ;-(

P: n/a
1)Access2003, beating my head against the wall, every other iteration
is "can't find macro Upshift" followed by carefully verifying that no
blank properties have been entered. Making NO changes at all,
sometimes the message goes away, sometimes not. Any clues?

2)The other headbeating iterations are due to no joy when trying to
allow T,F,Blank in a 1-character field, with AutoTab enabled.

InputMask:>C;;
DefaultValue:
ValidationRule:In("T","F"," ")

everybody says "Works for me!", but it doesn't work for ME: Upshift
works, T works, F works, but space does not; I get my ValidationMessage
(identical to the rule).

I've checked the field in my table:
FieldSize:1
Format:
InputMask:>C;;
Caption:
DefaultValue:
ValidationRule:In("T","F"," ")
Required:No
AllowZeroLength:Yes

any ideas please?

Aug 16 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

<ke**************@comcast.netschreef in bericht news:11**********************@75g2000cwc.googlegro ups.com...
1)Access2003, beating my head against the wall, every other iteration
is "can't find macro Upshift" followed by carefully verifying that no
blank properties have been entered. Making NO changes at all,
sometimes the message goes away, sometimes not. Any clues?

2)The other headbeating iterations are due to no joy when trying to
allow T,F,Blank in a 1-character field, with AutoTab enabled.

InputMask:>C;;
DefaultValue:
ValidationRule:In("T","F"," ")

everybody says "Works for me!", but it doesn't work for ME: Upshift
works, T works, F works, but space does not; I get my ValidationMessage
(identical to the rule).

I've checked the field in my table:
FieldSize:1
Format:
InputMask:>C;;
Caption:
DefaultValue:
ValidationRule:In("T","F"," ")
Required:No
AllowZeroLength:Yes

any ideas please?
About the blank:
By default Access trims spaces, so a single space is NOT saved.
I guess you have to change your rule here.

Maybe simply allow Null ? or (if you HAVE to) allow ZLS (zero lenght string "")
But I consider ZLS a bad idea (same goes for the space...) because you don't 'see' anything in the field while it is not-Null.

Arno R
Aug 16 '06 #2

P: n/a
BUT I've seen it work!! (just can't seem to figure out how to repeat
it!)

I appreciate your contrib re auto-trim of spaces, but that spaces is
why I'm specifically using the mask >C;; (as opposed to >l;;), meaning
upshift "Any character or a space (entry optional)". And the whole
idea is to let the user see nothing, making the T's stand out a lot
better. question stands: how to make this actually work?

BTW I tried adding "" to the FORM's validation rule; the result is the
dread can't find macro bit.

I submitted the q to an expert who came back with "Works for me!"; he
mentioned that his rules were applied to the table before creating the
form. That's not the sequence of events here, but with my Access
experience so far, I'll not be terribly surprised to discover that's a
factor.

And does anyone have a good way to search for the non-existent errant
macro? This dang tool (toy?) really doesn't want me under the hood!

Still seeking knowledge, not speculation - I've tried lots of that
thanks!

Tracy
Arno R wrote:
<ke**************@comcast.netschreef in bericht news:11**********************@75g2000cwc.googlegro ups.com...
1)Access2003, beating my head against the wall, every other iteration
is "can't find macro Upshift" followed by carefully verifying that no
blank properties have been entered. Making NO changes at all,
sometimes the message goes away, sometimes not. Any clues?

2)The other headbeating iterations are due to no joy when trying to
allow T,F,Blank in a 1-character field, with AutoTab enabled.

InputMask:>C;;
DefaultValue:
ValidationRule:In("T","F"," ")

everybody says "Works for me!", but it doesn't work for ME: Upshift
works, T works, F works, but space does not; I get my ValidationMessage
(identical to the rule).

I've checked the field in my table:
FieldSize:1
Format:
InputMask:>C;;
Caption:
DefaultValue:
ValidationRule:In("T","F"," ")
Required:No
AllowZeroLength:Yes

any ideas please?

About the blank:
By default Access trims spaces, so a single space is NOT saved.
I guess you have to change your rule here.

Maybe simply allow Null ? or (if you HAVE to) allow ZLS (zero lenght string "")
But I consider ZLS a bad idea (same goes for the space...) because you don't 'see' anything in the field while it is not-Null.

Arno R
Aug 16 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.