none
AC.2013 (Table) property Value is too large RRS feed

  • Question

  • Hi, Table.Design

    move some columns,....

    Do You Want To Save Changes To The Layout Of Table....YES

    ERROR: property Value is too large......iconfused.gif

    Sub ADHOC_TABLE_FIELDS_PROPERTY_VAL_LEN_CHECK()
    On Error Resume Next
    Dim i As Long, i2 As Long, lc1 As String, lc0 As String, lc_TT As String
    lc_TT = "ZZ_TBL_INI_W1_DFT"
    Debug.Print lc_TT
    For i2 = 0 To CurrentDb.TableDefs(lc_TT).Fields.Count
    For i = 0 To CurrentDb.TableDefs(lc_TT).Fields(i2).Properties.Count
        lc1 = i2 & "." & i & ", FLD.NAME=" & CurrentDb.TableDefs(lc_TT).Fields(i2).Name & ", PROP.NAME=" & CurrentDb.TableDefs(lc_TT).Fields(i2).Properties(i).Name
        lc0 = ""
        lc0 = CurrentDb.TableDefs(lc_TT).Fields(i2).Properties(i).Value
        lc1 = lc1 & ", PROP.LEN=" & Len(lc0) & ", PROP.VAL=" & lc0
        If Len(lc0) > 150 Then Debug.Print lc1
    Next i
    Next i2
    End Sub

    70.22, FLD.NAME=V1, PROP.NAME=Description, PROP.LEN=162, PROP.VAL=V1:     V# NE-FAR......

    property Value is too large....property Value MAX LENGHT =............162 ( 162 is too much ?)


    dBase,FoxPro,MS Access 2003,(2010=Not rec.),Office 2010+ACC.2013 ,Symbian C++, AC.2013.SystemResource.GetCurrentFreeSize=?

    Thursday, July 30, 2015 12:09 PM

All replies

  • 2cryptic

    Your code does not prove anything, because the property value did not get saved.

    We need a solid reproducible scenario. Do this:

    1. create a new empty database, copy the table in question to it (structure only).

    2. Reduce the problem to the minimal number of steps.

    3. Run psr.exe and record those steps.

    4. Post the database and the psr output to a public place, like a free OneDrive account.


    -Tom. Microsoft Access MVP

    • Proposed as answer by David_JunFeng Thursday, August 13, 2015 9:17 AM
    Thursday, July 30, 2015 1:04 PM
  • AC_2013_PROP_TOO_LARGE__

    say if OK, for deletion


    dBase,FoxPro,MS Access 2003,(2010=Not rec.),Office 2010+ACC.2013 ,Symbian C++, AC.2013.SystemResource.GetCurrentFreeSize=?

    Thursday, July 30, 2015 2:06 PM
  • >>> 

    70.22, FLD.NAME=V1, PROP.NAME=Description, PROP.LEN=162, PROP.VAL=V1:     V# NE-FAR......

    property Value is too large....property Value MAX LENGHT =............162 ( 162 is too much ?)

    Property.Value Property

    The setting or return value is a Variant data type that evaluates to a value appropriate for the data type, as specified by the Type property of an object.

    Could you provide more details about your issue, will help us reproduce and resolve it.

    For more information, click here to refer about Property.Value Property

    Monday, August 3, 2015 2:36 AM