Validation Rule in VBA to determine the length of text
I have a form for recording the phone numbers which have two kinds:
Internal has 4 characters
External has 4 or 7 or 8 characters
I want to make the ValidationRule change according to the Combobox that determines the type of phone numbers.
I tried to use ValidationRule in the form properties but it doesn't work with IIf formula or dependening on the value of another textbox or combobox.
So I made this piece of code, but it doesn't work:
If me.combo.value = "internal" then
Me.field.validationrule = "Len([field]) = 4"
ElseIf Me.combo.value = "external" Then
Me.field.validationrule = "Len([field]) = 4 or Len([field]) = 7 or Len([field]) = 8"
End If
Thanks in advance.
vba ms-access validationrule
edited Nov 25 '18 at 19:03
Lee Mac
4,05631440
asked Nov 25 '18 at 17:52
SaroojSarooj
177
add a comment |
I have a form for recording the phone numbers which have two kinds:
Internal has 4 characters
External has 4 or 7 or 8 characters
I want to make the ValidationRule change according to the Combobox that determines the type of phone numbers.
I tried to use ValidationRule in the form properties but it doesn't work with IIf formula or dependening on the value of another textbox or combobox.
So I made this piece of code, but it doesn't work:
If me.combo.value = "internal" then
Me.field.validationrule = "Len([field]) = 4"
ElseIf Me.combo.value = "external" Then
Me.field.validationrule = "Len([field]) = 4 or Len([field]) = 7 or Len([field]) = 8"
End If
Thanks in advance.
vba ms-access validationrule
edited Nov 25 '18 at 19:03
Lee Mac
4,05631440
asked Nov 25 '18 at 17:52
SaroojSarooj
177
add a comment |
I have a form for recording the phone numbers which have two kinds:
Internal has 4 characters
External has 4 or 7 or 8 characters
I want to make the ValidationRule change according to the Combobox that determines the type of phone numbers.
I tried to use ValidationRule in the form properties but it doesn't work with IIf formula or dependening on the value of another textbox or combobox.
So I made this piece of code, but it doesn't work:
If me.combo.value = "internal" then
Me.field.validationrule = "Len([field]) = 4"
ElseIf Me.combo.value = "external" Then
Me.field.validationrule = "Len([field]) = 4 or Len([field]) = 7 or Len([field]) = 8"
End If
Thanks in advance.
vba ms-access validationrule
edited Nov 25 '18 at 19:03
Lee Mac
4,05631440
asked Nov 25 '18 at 17:52
SaroojSarooj
177
I have a form for recording the phone numbers which have two kinds:
Internal has 4 characters
External has 4 or 7 or 8 characters
I want to make the ValidationRule change according to the Combobox that determines the type of phone numbers.
I tried to use ValidationRule in the form properties but it doesn't work with IIf formula or dependening on the value of another textbox or combobox.
So I made this piece of code, but it doesn't work:
If me.combo.value = "internal" then
Me.field.validationrule = "Len([field]) = 4"
ElseIf Me.combo.value = "external" Then
Me.field.validationrule = "Len([field]) = 4 or Len([field]) = 7 or Len([field]) = 8"
End If
Thanks in advance.
vba ms-access validationrule
vba ms-access validationrule
edited Nov 25 '18 at 19:03
Lee Mac
4,05631440
asked Nov 25 '18 at 17:52
SaroojSarooj
177
edited Nov 25 '18 at 19:03
Lee Mac
4,05631440
asked Nov 25 '18 at 17:52
SaroojSarooj
177
edited Nov 25 '18 at 19:03
Lee Mac
4,05631440
edited Nov 25 '18 at 19:03
Lee Mac
4,05631440
edited Nov 25 '18 at 19:03
Lee Mac
4,05631440
4,05631440
asked Nov 25 '18 at 17:52
SaroojSarooj
177
asked Nov 25 '18 at 17:52
SaroojSarooj
177
asked Nov 25 '18 at 17:52
SaroojSarooj
177
177
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
You don't have to change the validation rule. Try something like this instead:
([combo]="internal" And Len([field])=4) Or ([combo]="external" And (Len([field])=4 Or Len([field])=7 Len([field])=8))
answered Nov 25 '18 at 18:03
Wolfgang KaisWolfgang Kais
2,8622412
Thanks I got the vba code for which I ask
– Sarooj
Nov 26 '18 at 11:22
add a comment |
The code for which I ask
If me.combo.value = "enteral" then Me.field.validationrule ="Is Null OR Like """"" Elseif me.combo.value = "extetnal" then. Me.field.validationRule="Is Null OR Like """" OR Like """" OR Like """""
End if.
The source
https://www.officena.net/ib/topic/87200-التحكم-بخاصية-قاعدة-التحقق-من-الصحة-validationrule-لمربع-نص-برمجياً-vba/
answered Nov 26 '18 at 11:27
SaroojSarooj
177
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53470254%2fvalidation-rule-in-vba-to-determine-the-length-of-text%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You don't have to change the validation rule. Try something like this instead:
([combo]="internal" And Len([field])=4) Or ([combo]="external" And (Len([field])=4 Or Len([field])=7 Len([field])=8))
answered Nov 25 '18 at 18:03
Wolfgang KaisWolfgang Kais
2,8622412
Thanks I got the vba code for which I ask
– Sarooj
Nov 26 '18 at 11:22
add a comment |
You don't have to change the validation rule. Try something like this instead:
([combo]="internal" And Len([field])=4) Or ([combo]="external" And (Len([field])=4 Or Len([field])=7 Len([field])=8))
answered Nov 25 '18 at 18:03
Wolfgang KaisWolfgang Kais
2,8622412
Thanks I got the vba code for which I ask
– Sarooj
Nov 26 '18 at 11:22
add a comment |
You don't have to change the validation rule. Try something like this instead:
([combo]="internal" And Len([field])=4) Or ([combo]="external" And (Len([field])=4 Or Len([field])=7 Len([field])=8))
answered Nov 25 '18 at 18:03
Wolfgang KaisWolfgang Kais
2,8622412
You don't have to change the validation rule. Try something like this instead:
([combo]="internal" And Len([field])=4) Or ([combo]="external" And (Len([field])=4 Or Len([field])=7 Len([field])=8))
answered Nov 25 '18 at 18:03
Wolfgang KaisWolfgang Kais
2,8622412
answered Nov 25 '18 at 18:03
Wolfgang KaisWolfgang Kais
2,8622412
answered Nov 25 '18 at 18:03
Wolfgang KaisWolfgang Kais
2,8622412
answered Nov 25 '18 at 18:03
Wolfgang KaisWolfgang Kais
2,8622412
2,8622412
Thanks I got the vba code for which I ask
– Sarooj
Nov 26 '18 at 11:22
add a comment |
Thanks I got the vba code for which I ask
– Sarooj
Nov 26 '18 at 11:22
Thanks I got the vba code for which I ask
– Sarooj
Nov 26 '18 at 11:22
Thanks I got the vba code for which I ask
– Sarooj
Nov 26 '18 at 11:22
add a comment |
The code for which I ask
If me.combo.value = "enteral" then Me.field.validationrule ="Is Null OR Like """"" Elseif me.combo.value = "extetnal" then. Me.field.validationRule="Is Null OR Like """" OR Like """" OR Like """""
End if.
The source
https://www.officena.net/ib/topic/87200-التحكم-بخاصية-قاعدة-التحقق-من-الصحة-validationrule-لمربع-نص-برمجياً-vba/
answered Nov 26 '18 at 11:27
SaroojSarooj
177
add a comment |
The code for which I ask
If me.combo.value = "enteral" then Me.field.validationrule ="Is Null OR Like """"" Elseif me.combo.value = "extetnal" then. Me.field.validationRule="Is Null OR Like """" OR Like """" OR Like """""
End if.
The source
https://www.officena.net/ib/topic/87200-التحكم-بخاصية-قاعدة-التحقق-من-الصحة-validationrule-لمربع-نص-برمجياً-vba/
answered Nov 26 '18 at 11:27
SaroojSarooj
177
add a comment |
The code for which I ask
If me.combo.value = "enteral" then Me.field.validationrule ="Is Null OR Like """"" Elseif me.combo.value = "extetnal" then. Me.field.validationRule="Is Null OR Like """" OR Like """" OR Like """""
End if.
The source
https://www.officena.net/ib/topic/87200-التحكم-بخاصية-قاعدة-التحقق-من-الصحة-validationrule-لمربع-نص-برمجياً-vba/
answered Nov 26 '18 at 11:27
SaroojSarooj
177
The code for which I ask
If me.combo.value = "enteral" then Me.field.validationrule ="Is Null OR Like """"" Elseif me.combo.value = "extetnal" then. Me.field.validationRule="Is Null OR Like """" OR Like """" OR Like """""
End if.
The source
https://www.officena.net/ib/topic/87200-التحكم-بخاصية-قاعدة-التحقق-من-الصحة-validationrule-لمربع-نص-برمجياً-vba/
answered Nov 26 '18 at 11:27
SaroojSarooj
177
edited Nov 26 '18 at 14:28
answered Nov 26 '18 at 11:27
SaroojSarooj
177
answered Nov 26 '18 at 11:27
SaroojSarooj
177
answered Nov 26 '18 at 11:27
SaroojSarooj
177
177
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53470254%2fvalidation-rule-in-vba-to-determine-the-length-of-text%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
