Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2023
    Posts
    4

    Changes to field information that are not being shown correctly


    Hello - I have changed how I wish information to be displayed in a form field. However, even though I can see the change is correct within the Table field, it does not show correctly within the form field. I have checked another DB that I have used the same method for display and they are identical. Help please. Thank you in advance. Janice

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I think we need to see your database, or a cut down version that shows this issue.

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    What data type are we talking here?, as any form formatting will override table formatting?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    xps35's Avatar
    xps35 is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jun 2022
    Location
    Schiedam, NL
    Posts
    229
    Remove the field from the form and put it back again. The properties of the form field are set according the table properties when you place the field and will not be updated automatically when you change the table.
    Groeten,

    Peter

  5. #5
    Join Date
    Mar 2023
    Posts
    4
    Thank you for your time - it was as simple as deleting and re-entering; which I had done, but clearly needed a bit more nudging!

  6. #6
    Join Date
    Mar 2023
    Posts
    4
    Than k you so much - even though I had done this, I only needed to (again) delete and re-enter.

  7. #7
    Join Date
    Mar 2023
    Posts
    4
    Thank you Peter - this worked. I had done this, but for whatever reason it worked the second time.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 09-13-2019, 04:48 AM
  2. Replies: 1
    Last Post: 04-24-2016, 06:04 AM
  3. Replies: 4
    Last Post: 06-25-2015, 01:35 PM
  4. Replies: 3
    Last Post: 07-24-2012, 07:35 AM
  5. Replies: 3
    Last Post: 04-25-2012, 02:14 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums