ESdat Forums
»
Forums
»
ESdat
»
New Environmental Standards Description field limited to 255 characters
 Rank: Member
Groups: Registered
Posts: 14
|
The new ability to add a description for each environmental standard in version 4.3 limits the description to 255 characters in the Access version. Can this be altered?
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498  Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)
|
It is limited to 255 characters in Access versions as to allow more characters than that requires a Memo field, and unless you have a need for it, and we don't expect most users to, we prefer to avoid memo fields. You can change it to a Memo field by opening the database in Access and changing the field to Memo there. Another way to change it to Memo is to select Setup - Run Command (in ESdat) and paste and run the following: ALTER TABLE zRef_Environmental_Standards_Config ALTER COLUMN Description MEMO (Applies only to versions > 4.3, using Access backend database) Edited by moderator Sunday, November 27, 2011 3:27:03 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
New Environmental Standards Description field limited to 255 characters
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.