My text field in the table is filled from the database with a single row, and I want my text to be interrupted before the first parenthesis, to move to the second row.  

Hello, I have a product list in Dynamic PDF which is connected to a Access DB.My Product Name field look like that :Primary Product Name (Secondary Product Name) I want to replace " (" with "\n" (new line, or break). How I can obtain a field with 2 lines? Any ideas ? I want a <BR> or \n after "Prima...

Now i have a connection to the Access DB(.mbd) and everything works good. All what i did is to click "Build" and replace the DSN from ODBC Data Source Administrator with other Access DB (.accdb) with same tabels and same query. But in PDF forms i get only first column from first Table from DataBase....

Uhm, , for the moment my PDF`s are connected to a old access DB , and everytime when i want to upgrade product lists, i need to open Access and update manually to get the list updated in PDF`s. Do you have any ideea how i can automate that ? ... I the way i told you, with macro from excel who updat...

Yea, correct, but when replace de DB, binding still exist, because i dont delete the old connection, i just change the settings for existing connection and livecycle keep all fields binded with fields from DB

Ok, why i want to replace the database .... I created a linked table in Acces, from an excel file, and when i modify values in excel, automatically updates in Access.. I use this solution for updating product lists in all pdfs in same time. .. The new database is a duplicate of first db (wich works ...

My working binding is "use name" instead of "$record.dataconnection..." . The problem appear when i change the database with other one identic. Choose Connection Proprietes , select the new ODBC user data source name, the query is correct... and when i open PDF file, it fills just first field...

yes, the problem is that in livecycle it brings me data only in the first field (dropdown) and I would like it to bring me records from the database in the all fields.

Hello, I created ODBC connection for Acces Database (.accdb)I have a form with multiple fields, ex : Product Name, Product No.,Category , etc , and i dont know why my form show only first record "Product Name". Can you help me ?Thanks  

Hello Craig-MDS,Check out this sample I made for you.http://bit.ly/2c7ZwGGI hope it helps.