Limiting characters in memo field
Member Login:
e-mail:
password:
Register
Forgot Password
Search:
Entire Site
IT Answers
IT Blogs
Site FAQ
Home
>
IT Answers
>
Database
> Limiting characters in memo field
Olddog
10 pts.
Q:
Limiting characters in memo field
Microsoft Access
In Access how do I restrict the number of characters a user can enter into a memo field?
ASKED:
Apr 29 2008 1:36 AM GMT
Add to Watchlist
Report Objectionable Content
RSS - Question Updates
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
ILE RPG
Cpyf and *NOCHK
File open RPG
Alessandro.panzetta
9615 pts.
A:
RATE THIS ANSWER
0
Click to Vote:
0
0
Hello OldDog,
this cannot be done on a memo field but only to test fields. You may consider using some VBA code to check the length before insert/update (E.g.
If Len(text) > 123 then....
)
Bye
Last Answered:
May 29 2008 9:03 AM GMT
by
Alessandro.panzetta
9615 pts.
View History
A:
Hello OldDog, this cannot be done on a memo field but only to test fields. You may consider using some VBA code to check the length before insert/update (E.g. [I]If Len(text) > 123 then....[/I]) Bye
Please complete the following information:
REGISTER / LOG-IN TO ANSWER QUESTION
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Submit your e-mail address below to continue
E-mail: 
E-mail:
Handle:
Password:
Forgot Password?
Create Handle:
Your handle identifies you in ITKnowledgeExchange. Max 30 char.
Create Password:
Confirm Password:
Yes, I agree to the IT Knowledge Exchange
Terms and Conditions.
hidden modal window
RSS - Discussions
Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Please complete the following information:
REGISTER / LOG-IN TO DISCUSS
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Submit your e-mail address below to continue
E-mail: 
E-mail:
Handle:
Password:
Forgot Password?
Create Handle:
Your handle identifies you in ITKnowledgeExchange. Max 30 char.
Create Password:
Confirm Password:
Yes, I agree to the IT Knowledge Exchange
Terms and Conditions.
hidden modal window
Ask a Question
Question Title:
(150 char. limit.)
Question:
(Please be specific.)
Tags:
(Separate each tag with a comma.)
What is a Tag?
Browse IT Answers by Topic
AS/400
Channel
CIO
CRM
Database
DataCenter
DataManagement
Development
Exchange
Linux
Lotus Domino
Microsoft Windows
Mobile
Networking
Oracle
SAP
Security
SQL Server
Storage
Virtualization
VoIP
>>
VIEW ALL TAGS