Increasing a Data Field Length

[Dwight]

Is there a way to increase a data field length using code.

I have an application that has a front end application and a back end
database. I would like to put a button on a form that allows a user to
increase the data field length to the corresponding field in the back end
database table.

Thank you in advance!

Dwight

 

[storrboy]

Is there a way to increase a data field length using code.

I have an application that has a front end application and a back end
database. I would like to put a button on a form that allows a user to
increase the data field length to the corresponding field in the back end
database table.

Thank you in advance!

Dwight

Kind of a waste of time.
Either set the length in the table to the maximum you think will be
used, or make it a memo that people will likely never fill.
Constantly adjusting field settings would probably cause more problems
than it's worth.

 

[BruceM]

Even if it is possible to adjust the length using code, the setting would
apply to all records. Somebody would eventually set the size to the maximum
(unless it is a Memo field), after which no further adjustments would be
possible. You may as well set the field to the needed size, as suggested
previously. I doubt you want to give your users design control over a back
end table in any case.

 

[Dwight]

I underestimated the field length when the application was released. I want
the user to be able to update the data field without losing his/her data. It
is a one-time fix.

Thanks!

 

[Wayne-I-M]

Hi Dwight

Storrboy is right. You will not lose any data by increasing the field size.

But, if a user were to increase a field and then fill it then another user
changed the sise so the 1st users data would not not fit - you (the IT dept)
would have a big problem.

 

[Dwight]

The table consists of 1 record.
What I plan on doing is checking the field length when the form is loaded,
and if the field is not set at the length it needs to be, then it will be
increased to a length that I will code. If the field length is correct, the
button will not even be displayed. I am trying increase a field length on
the back end without putting out a new back end.

Thanks!

Dwight

 

[Dwight]

Wayne,
It is a single user application. I am just trying to prevent putting a new
back end.

Thanks!

Dwight

 

[BruceM]

I misunderstood the question. However, the user would need permission to
modify the table's design using code (again, assuming it's possible). If
so, I would think the user could modify the back end directly. Are you in
another location that prevents you from modifying the back end yourself?

 

[Peter Hibbs]

Dwight

Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE Update Utility.mdb'

which will do this for you.

Peter Hibbs

 

[i_takeuti]

I misunderstood the question. However, the user would need permission to
modify the table's design using code (again, assuming it's possible). If
so, I would think the user could modify the back end directly. Are you in
another location that prevents you from modifying the back end yourself?