Re: How to create a memo field with a fixed length of 2000 charact

If you need to "pad" the outputted data string, then use this:

Left([long field] & String(2000," "),2000)

--

Ken Snell
<MS ACCESS MVP>

"Dawn Bjork Buzbee" <DawnBjorkBuzbee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:4FB8EA55-84B8-4109-BAF0-D835C3586948@xxxxxxxxxxxxxxxx
> Thank you. I should have been clearer: due to the fact that a memo field
> can
> NOT be defined at a specific length, what would be the best way through
> queries, programming, etc. to create an end result of a 2000 character,
> fixed
> length field that is empty or only populated with spaces (whatever is
> needed
> to create a fixed length). No input is needed for this field; forms are
> only
> used to capture some of the client data; other fields are added because
> they
> are required by the system but are not used by the client. Would it work
> to
> use a calculated field such as left([long field],2000) in a query? Would
> this
> work even if the memo field does not contain data? Yes, the output is a
> text
> file.
> ---
> Thanks again,
> Dawn Bjork Buzbee
>
>
> "Ken Snell [MVP]" wrote:
>
>> You cannot fix the memo field to a specific length as a property in the
>> table's design. You'll either need to limit it via programming in the
>> form
>> that is used for data entry, or limit it via a calculated field (that
>> only
>> selects the first 2000 characters of the field's contents) in the query
>> that
>> is used to export the data to a file (I assume text file).
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>> "Dawn Bjork Buzbee" <DawnBjorkBuzbee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> message news:63473AE2-B8E3-42E6-A937-5E18F0BC1810@xxxxxxxxxxxxxxxx
>> >I need to create an Access field with a fixed length of 2000 characters.
>> >This
>> > field is part of a fixed length flat file of billing data that will be
>> > uploaded on a weekly basis to an Oracle application. The field only
>> > exists
>> > as
>> > a placeholder for possible future fields; the length was set by the
>> > developer.
>> >
>> > Once I establish a process for generating this field, do I need to fill
>> > it
>> > with spaces to "hold" the length?
>> >
>> > Thank you in advance for your time and expertise,
>> >
>> > --
>> > Dawn Bjork Buzbee
>>
>>
>>


.

Relevant Pages